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

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

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

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

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