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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating days between two dates
April 21, 1900 corresponds to the number 112. Your cell is formatted as a
date. Nov 17, 2006 was 112 days ago. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "lledelen" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating days between two dates
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating days between two dates
The cell where you had put your formula is formatted as a date. Format it as
"General". Format-Cells, in the Number tab, select "General" in the Category list. "lledelen" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |