how many days
 

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

how many days
 

Hi

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

his will do the job.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Jean-Paul" wrote:

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

how many days
 

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
---------------
Jacob Skaria


"Jean-Paul" wrote:

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

how many days
 

Hello,

Maybe the fourth formula at
http://www.sulprobil.com/html/date_formulas.html
can help you.

Regards,
Bernd

how many days
 

this returns 94 instead of 130....
So I think the formula isn't correct

Jacob Skaria wrote:
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
---------------
Jacob Skaria


"Jean-Paul" wrote:

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