D
DME
Is there a funtion that counts the numbers of days between two dates?
Thaks for the help!
Thaks for the help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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 **
--
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 **
P
Peter Atherton
DME-----Original Message-----
Is there a funtion that counts the numbers of days between two dates?
Thaks for the help!
A simple subtraction formatted asGeneral will do the trick.
But if you want to exclude weekends and holidays try
NETWORKDAYS
Peter
F
Frank Kabel
Hi
simply:
=A2-A1
and format as 'Number'
simply:
=A2-A1
and format as 'Number'
D
DME
Thanks! A little stupidity entered my brain and I didn't think that it
would be that eay.
would be that eay.