We help IT Professionals succeed at work.

Every April 1 and Oct 1 of each year

pdvsa asked
Experts, The below formula gives me each Jan and July 15 of each year and I now need April 1 and Oct 1 of each year.  How to modify?  thank you in advance.

Watch Question

Most Valuable Expert 2013
That formula will give you Jan 15 and Jul 15 if those are workdays, otherwise it gives you the previous working day - if you want the same setup but for April 1 and Oct 1 then, of course, the previous working day might be in March or September, is that OK?

That also complicates matters because the date might not be in the expected month. This formula should work regardless of the distribution of holidays, assumes A1 contains the first April 1 or Oct 1 with formula in A2 copied down


regards, barry
pdvsaProject finance


Perfect.  Preceding is OK for me.  thank you much....