Working Days in a Month

[Vipin Vijayan]

Hi all,

Is there any way to list out all the working days in a month?


Regards

Vipin

 

[Luke M]

If A1 contains a date, this would give you list (copied down)
=IF(MONTH(WORKDAY(EOMONTH($A$1,-1),ROWS(B$1:B1)))>MONTH($A$1),"",WORKDAY(EOMONTH($A$1,-1),ROWS(B$1:B1)))
Copy down 30 cells. Only working days for that month will be visible.

 

[Mike H..]

Hi all,

Is there any way to list out all the working days in a month?


Regards

Vipin

Hi,

Enter a date of your choosing in D1 then this formula in A1 will return the first working day of the month.

=WORKDAY(DATE(YEAR(D1),MONTH(D1),1)-1,1,Holidays)

Then this formula in A2. Drag down to produce all the other working days for the month of the date in D1. Drag down far enough to ensure you have enough rows, the formula returns blanks when it runs out of working days for the month.

=IFERROR(IF(MONTH(WORKDAY(A1,1,Holidays))=MONTH($A$1),WORKDAY(A1,1,Holidays),""),"")

Note each formula refers to a named range called 'Holidays' create this named range and enter in it any holiday dates to be ignored.

 

[NARAYANK991]

Hi Vipin ,

See this file ; the array {2,3,4,5,6} defines the working days , while Holidays is a named range.

Narayan

 

[Debraj]

Just a KISS-metrics..

• Enter the starting Work day of month.
• Drag downward using RIGHT CLICK..
• From the pop-up select.. Fill Weekdays

 

[NARAYANK991]

Hi Debraj ,

A couple of points ; when you follow the procedure you have outlined , is it possible :

1. To specify holidays

2. To specify a different set of weekdays ; there are places where the week is from Saturday to Friday , with Thursday and Friday as the weekends

Narayan