Weekend or Holiday should be Next weekday

[Clarence Perdue Jr.]

Hello,

I have a payment report which has a payment date that has to be paid the following day which can not be on a holiday or weekend. If the follow date is a weekend or holiday, I move to the next date that is Monday to Friday. Can someone help me with this problem.

Thanks in advance

Clarence Perdue Jr.

 

[NARAYANK991]

Hi Clarence ,

A similar problem has been addressed in this thread :

http://chandoo.org/forum/threads/exclude-a-public-holiday-in-an-if-statement.19371/#post-116732

Narayan

 

[Haseeb A]

Hello Clarence,

That is exactly WORKDAY function doing. Enter your all Holidays in a range, then use like

=WORKDAY(A1,1,H$1:H$10)

A1: The date
H1:H10: Holidays

Change the cell reference with your structure.

 

[Clarence Perdue Jr.]

Hello Clarence,

That is exactly WORKDAY function doing. Enter your all Holidays in a range, then use like

=WORKDAY(A1,1,H$1:H$10)

A1: The date
H1:H10: Holidays

Change the cell reference with your structure.

I want to do this for holidays and weekend Saturday and Sunday.

 

[NARAYANK991]

Hi Clarence ,

Can you see the Excel help on the WORKDAY function here :

http://office.microsoft.com/en-in/starter-help/workday-function-HP010343038.aspx?redir=0

The function excludes weekends and specified holidays.

Narayan

 

[Clarence Perdue Jr.]

Hi Clarence ,

Can you see the Excel help on the WORKDAY function here :

http://office.microsoft.com/en-in/starter-help/workday-function-HP010343038.aspx?redir=0

The function excludes weekends and specified holidays.

Narayan

Yes, I was able to get the result from this information. I would like to thank you for this information.