| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how many days
Hello,
Maybe the fourth formula at http://www.sulprobil.com/html/date_formulas.html can help you. Regards, Bernd |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Linear Mode
