CODEWITHSUNDEEP
excelexcel-formula
Vivek
Vivek

Reputation: 11

Excel formula for first day of the week without holidays

Want to know the excel formula for the first business day of the week without holidays. So far I have

=D2-WEEKDAY(D2,2)+1

where D2 is today's date. This formula is giving me the first day of the week but I also want it to skip holidays.

Upvotes: 0

Views: 123

Answers (1)

Scott Craner
Scott Craner

Reputation: 152465

You want to wrap the return date in WORKDAY and locate a list of holidays(I put mine in column F)

=WORKDAY(D2-WEEKDAY(D2,2),1,F1:F8)

enter image description here

Upvotes: 0

Related Questions