Calculation to determine days between two dates

D

Dubleaa

I am trying to determine if it is possible to write a calculation in Excel
that will tell me how many days have elapsed from 5/17/1995 to 3/15/2005.
 
A

Alan

Dubleaa said:
I am trying to determine if it is possible to write a calculation in
Excel that will tell me how many days have elapsed from 5/17/1995 to
3/15/2005.
Click to expand...

=VALUE("15/3/05")-VALUE("17/5/95")

= 3590 days

OR

=TODAY()-Value("17/5/95")

= 3592 days at the time of posting.

The second if you always want it to 'today'.

HTH,

Alan.
 
Top