| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating days between two dates
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Days Between Dates | New Users to Excel | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Problem calculating Days/Hours etc between 2 dates | Excel Discussion (Misc queries) | |||
| calculating number of days (e.g., Mondays) between two dates | Excel Worksheet Functions | |||
| Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Threaded Mode
