How to Get Holiday in VBA Code

[punnipah]

Hi,,



I want to write the date on excel 3 days in advance but not counting weekend and holidays.

How to type VBA Code

Range("D4").Value = Format(DateAdd("d", 3, Date), "D MMM YY")



Thank you .

 

[Saurabhj]

Hi,

Check below:

Range("D4").Value = Format(WorksheetFunction.WorkDay(Date, 3, Sheets("Sheet2").Range("A1:A3")), "D MMM YY")

Range A1 to A3 contains Holiday dates.

Book1
	A	B	C
1	04-Feb-22
2	07-Feb-22
3	15-Feb-22
4
5
6
7
Sheet2

 

[punnipah]

Thank y

Hi,

Check below:

Range("D4").Value = Format(WorksheetFunction.WorkDay(Date, 3, Sheets("Sheet2").Range("A1:A3")), "D MMM YY")

Range A1 to A3 contains Holiday dates.

Book1
	A	B	C
1	04-Feb-22
2	07-Feb-22
3	15-Feb-22
4
5
6
7
Sheet2

Thank you very much.

 

[Saurabhj]

Great. Thanks for the feedback.