A calculation to count the number of days 1

[sooze29]

I need to count the number of days between two dates over a period of years. This should include weekends, as I need to include every single day.

NETWORKDAYS - counts working days
COUNT360 - Only counts days based on a year of 360 days.

Does anyone know another formula?

Many thanks

 

[SkipVought]

hi,

Merely calculate the difference, since Date/Time units are days.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[sooze29]

Not sure what you mean?

 

[SkipVought]

It is simply the mathematical difference between the two dates (A-B).

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[sooze29]

Oh my goodness, you think something is going to be tricky and its as simple as that. I cannot believe I didn't think, having trained it for about ten years! Actually the person that asked me threw me as they were using the networkday so I assumed there was a formula for this! Thanks

 

[SkipVought]

FYI...

faq68-5827

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[sooze29]

Thank you, I will keep that to hand.