Converting SAS date to and from Excel dates

Useful information: SAS assumes 1 Jan 1960 is day 0. Excel assumes 1 Jan 1900 is day 1. You can therefore add or subtract 21 916 from the date depending on whether you are going from Excel to SAS or SAS to Excel. Be careful of negative numbers. SAS accepts the date as being before 1 Jan 1960, Excel does not recognise it.

 

Learn more at our Excel courses. Visit www.AuditExcel.co.za Live Excel Training page