Date Formula

L

leanete

Can anyone help? I need to create a formula that will give me the
amount of days between two dates i.e., 01/31/05 - 01/01/05 = 30 days.
I know it's 30 because I used a sample that would be easy but I'm
working on a large amount that might be 60, 40 or so. I used the HELP
on Excel but it gives me i.e. 01/31/05 - 01/01/05 = 01/30/1900. What
am I doing wrong???

Please email me at [email protected]

REALLY NEED HELP...!
 
P

Paul Sheppard

leanete said:
Can anyone help? I need to create a formula that will give me th
amount of days between two dates i.e., 01/31/05 - 01/01/05 = 30 days.
I know it's 30 because I used a sample that would be easy but I'
working on a large amount that might be 60, 40 or so. I used the HEL
on Excel but it gives me i.e. 01/31/05 - 01/01/05 = 01/30/1900. Wha
am I doing wrong???

Please email me at [email protected]

REALLY NEED HELP...!
Click to expand...

Hi Leanete

Try formatting the cell where the result is as a number or as general

Pau
 
D

Dave O

Where your cell shows 01/30/1900, format that cell as a number- it's
currently formatted as a date. Then you'll get the result you expect.

Sorry, your email address truncated.
 
D

Duke Carey

Your math is correct - you just need to format the cell with the result so
that it displays as a number, not as a date. With the cell selected,
1) click on the Comma icon on the toolbar, or
2) press Ctrl-1 to pull up the Format Cells dialog box, go to the Number
tab, and pick one of the numeric type formats
 
Top