Count Days

[DME]

Is there a funtion that counts the numbers of days between two dates?

Thaks for the help!

 

[Paul B]

How about just subtracting the dates and format the cell as general?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Peter Atherton]

-----Original Message-----
Is there a funtion that counts the numbers of days between two dates?

Thaks for the help!

DME
A simple subtraction formatted asGeneral will do the trick.
But if you want to exclude weekends and holidays try
NETWORKDAYS

Peter

 

[Frank Kabel]

Hi
simply:
=A2-A1
and format as 'Number'

 

[DME]

Thanks! A little stupidity entered my brain and I didn't think that it
would be that eay.