How to enter dates

First open the spreadsheet (click the button) and enter a heading in the column that will contain the dates.

Next click the Format spreadsheet button :

On the Column tab, select the "Text format" option and increase the column width to e.g. 12 so there is enough space to enter dates. If you do not specify "Text format", MedCalc will display the number 0.0127551 when you enter a date as 5/7/56 (5 divided by 7 divided by 56).

Now you can start entering the dates. MedCalc allows to enter dates using a slash or dot or any non-numerical character as a separator: e.g. 01/05/1961.

When you enter a date with a year less than 100, MedCalc will interpret this year as a year in the 20th century: 20.12.88 = 20.12.1988. When you enter 0 as the year number, MedCalc will interpret this as the year 1900: 20.12.00 = 20.12.1900. So when you want to enter a date situated in the 19th or 21st century, enter the year using 4 digits: 01.01.2000.