G
Guest
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
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