Calculating days between two dates
Thanks! of course.... something I didn't even consider...
--
Thanks,
Laura
"Niek Otten" wrote:
Hi Laura,
Format as General
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"lledelen" wrote in message ...
| Hope someone can help.
|
| When trying to come up with the number of days between a date on my
| spreadsheet and the current date I am not getting the results in days.
|
| Date format on my spreadsheet for G2 - 11/17/2006 13:19
| Formula - =DATEDIF(G2,TODAY(),"D")
| Result - 4/21/1900 0:00
|
|
| --
| Thanks,
| Laura
|