how many days

J

Jean-Paul

Hi,
I need to know how many days there are between the beginning of this
year (01/01/09) and today without the weekends?
Any idea
Thanks
 
M

Martin Fishlock

Hi

There is a formula in the analysis toolpack add in for networkingdays.

his will do the job.
 
J

Jacob Skaria

With Start Date (01/01/09) in A1 the below formula will give you the number
of days including today .. Make sure you copy the formula to one single line.


=(TODAY()-WEEKDAY(TODAY(),2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,WEEKDAY(TODAY(),2))+1


If this post helps click Yes
 
Top