ExcelBanter - Calculating differences between dates

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculating differences between dates (https://www.excelbanter.com/excel-worksheet-functions/20664-calculating-differences-between-dates.html)

ALISONHELP

Calculating differences between dates

Can someone tell me what formula to use to calculate the difference between
two dates.
For example one date being 11/1/1987 and the other date being current.

Thank you,

Alison

Fredrik Wahlgren

"ALISONHELP" wrote in message
...
Can someone tell me what formula to use to calculate the difference
between
two dates.
For example one date being 11/1/1987 and the other date being current.

Thank you,

Alison

DateDif
http://www.cpearson.com/excel/datedif.htm

/Fredrik

elz64

microsoft.com...
Can someone tell me what formula to use to calculate the difference
between
two dates.
For example one date being 11/1/1987 and the other date being current.

1/ cell A1 contains the date you wanted
2/ cell b1 contains =TODAY() - must be depending on your language (for me
it's AUJOURD'HUI () )
3/ cell c1 =b1-a1 returns a number of days. You could use for A1 and b1 a
standard format instead of Date format . this will returns a serial number
instead of the 'readable date'

All times are GMT +1. The time now is 07:17 AM.