how many days

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
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
 
Hi

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

his will do the job.
 
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
 
this returns 94 instead of 130....
So I think the formula isn't correct
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Day of the Year 3
Formula ? 4
Access Count dates within a Month 4
calculate number of days 7
Subtracting number of days excluding the weekend 2
Counting Days 5
Count Dates between Dates exclude Text 3
MM/YY Formatting date Entry AND Display 2

Back
Top