Working Weeks

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

I want excel to display the dates of the working weeks.
I know that this can be accomplised by using the WORKDAYS Function bu
dont know how.

It should be possible to put the year's date in a cell and then th
formual can then display all the working weeks within that year
simmilary the same can be done for a month.

Any ideas
 
You can can get sequential workdays (M-F) and exclude
holidays by entering this in A2 and filling down:

=WORKDAY(A1,1,$G$1:$G$9)

where A1 is the first date and your holidays (the dates,
not the holiday names) are listed in G1:G9.

HTH
Jason
Atlanta, GA
 
Back
Top