Need Year to be Variable in Formula

D6 contains a date - April 6, 2014 - this date will automatically change to a new day in 2015 and so on for every new year (it is a floating holiday date, Good Friday).

G6 contains a number - 75.

I want to have the number in G6 replicated in A3 if the date in D6 is greater than or equal to April 1 and less than or equal to April 15.

This is the formula I have which works for 2014 but will not work when the year changes to 2015 and so on:

=IF(AND(D6>=DATE(2014,4,1),D6<=DATE(2014,4,15)),G6,0)

How can I make the year in the formula a variable so that it will look between April 1 and April 15 for any year?

Thank you.

Thank you for the speedy reply.

I will need to use the formula in 6 places in my workbook. I will test it out and let you know if it works as needed.

Again, thank you!

Hi Ford

Well it works for a portion of what I need but I have a glitch. The workbook spans a fiscal year of April to March so a portion of the workbook is in the current year and a portion is in the following year. Is there a way to make it look at the current year plus 1?

Jada

Hi Ford

I have worked around the glitch by realizing I goofed - forgot to change the reference year for the holiday calculations to the next year - I am a novice after all. Thank you so much for your help. It was the last thing I needed to finish my payroll workbook.

Jada

Thank you for marking it solved and goodnight.