Forum Discussion
Subtracting two dates that goes negitive
John-1952 You may consider to change a setting in Excel to "Use 1904 date system", as this will allow negative duration. Be aware, though, that your dates will be off by 4 years compared to using the 1900 date system, which is the default setting.
Google for "1904 date system" and you'll find plenty of sites explaining the difference between the two systems and how to change the settings in Excel.
John-1952 You may consider to change a setting in Excel to "Use 1904 date system", as this will allow negative duration. Be aware, though, that your dates will be off by 4 years compared to using the 1900 date system, which is the default setting.
Google for "1904 date system" and you'll find plenty of sites explaining the difference between the two systems and how to change the settings in Excel.
Thank you!! changing to 1900 date system worked Riny_van_Eekelen
