ExcelBanter - Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Dates (https://www.excelbanter.com/excel-discussion-misc-queries/128433-dates.html)

DHM

Dates

How do i calculate the number of days between 3 dates, 09/01/2006 thru 01/23/06

T. Valko

Dates

Just subtract:

A1 = 9/1/2006
A2 = 1/23/2006

=A1-A2

Format as GENERAL or NUMBER

Result = 221

Biff

"DHM" wrote in message
...
How do i calculate the number of days between 3 dates, 09/01/2006 thru
01/23/06

All times are GMT +1. The time now is 09:56 AM.