Adding Day to find a next weekday
The issue with your response is that the function you suggest will only count
workdays. As I indicated in my reply I want to count weekend days and
holidays.
Thanks
"Teethless mama" wrote:
Let's say
A1: Start date
A2: number of workdays
A3:A5 Holidays
=WORKDAY(A1,A2,A3:A5)
Adjust to suit your needed
"Dolt" wrote:
I have already set up the spreadsheet to find the next date excluding
counting weekends and holidays but I want to count ALL those days (holidays &
weekends) to find the next date. So, if the say 60th day ends on a holiday or
weekend the result I get back is the next available workday.
"Teethless mama" wrote:
Take a look WORKDAY function
"Dolt" wrote:
Ok, I am trying to create a function that does the following..
Adds X amount of days to a particular day including ALL days but returning a
result that is not a weekend or holiday.
I have a grid of dates with a vertical range of saturday dates, sunday dates
and an array of holiday dates.
Essentially, I have been trying to add, say, 60 days to a date. Then trying
to compare it with vlookup to each one of these using the vlookup's below b4
is the date, c2= 60, if its true it lists the date that matches.
=VLOOKUP(B4+C2,l4:l56,1,FALSE)
=VLOOKUP(B4+C2,A4:A56,1,FALSE)
=VLOOKUP(B4+C2,A59:e65,1,FALSE)
What I've tried to do is add 1 or 2 days to make it reach the next
non-holiday weekday date. But my syntax on the functions is not working out.
Any help is appreciated
|