# Every Oct 8

experts, i need a formula for each oct 8 of each year.  t should be draggable down several rows from start date in A1. if oct 8 is a weekend then i need preceding workday.

thank you
###### Who is Participating?

EngineerCommented:
Try this formula in A2 and drag down

=DATE(YEAR(A1)+1,10,8-MAX(0,WEEKDAY(DATE(YEAR(A1)+1,10,8),2)-5))
0

Commented:
HI

Would you be able to provide an excel template that we can work with?

This should help us to understand what you really need.
0

Project financeAuthor Commented:
Hi, I am on my phone at the moment.

Let's say cell a1 is October 8, 2015.  I need out 8 of each succeeding year and using previous workday if lands on a weekend.

Thank you
I hope my explanation is clear.
0

Project financeAuthor Commented:
Saqib, that works.

Would you happen to know how I could incorporate a holidays named range?  I have a tab with a listing of holidays and if the date lands on the holiday then use the preceding workday.
0

EngineerCommented:
Unless you have oct 6th or oct 7th as a holiday you probably do not have to worry about holidays.
0

Commented:
...a bit late for this one, I know.......but if you use WORKDAY function you can exclude holidays if that might be a factor, i.e. using this formula in A2 copied down

=WORKDAY(DATE(YEAR(A1)+1,10,8)+1,-1,holidays)

regards, barry
0

Project financeAuthor Commented:
Thank you Barry.  I will test that when I return to my computer.  Appreciate your response after knowing that the question was closed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.