DATE + 15 CAN NOT END ON WEEKEND OR HOLIDAY

RMART

New Member
Joined
Sep 12, 2002
Messages
1
I am trying to calculate a due date that is 15 days in the future. If the 15th day is a weekend or holiday (Xmas or New Years) I need the due date to be the next available weekday.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
See the Workday function (requires that analyst tool pak be installed). this does exactly what you want.
 

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
Just checking some old postings and I think I may have steered you wrong here. Workday is still your function, but I orignally had a formula such as

=WORKDAY(A1,15,myholidays)

in mind, where myholidays is a named range containing your holidays.
This will add 15 non-weekend non-holidays to your date in A1. But sounds like you want to count 15 days (weekend, holiday, or not) and just not land on a weekend or holiday.
I believe

=WORKDAY(A1+14,1,myholidays)

would get you there.

Good luck
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,504
Members
412,672
Latest member
vitaminshop20
Top