Show Jan 15 and July 15 of each year
Posted on 2014-09-24
What would be the formula to show the next date of either Jan 15 or July 15?
Example: formula should return Jan 15, 2015 and then once that date is passed then will show July 15, 2015.
hope that makes sense. Please ask to explain in more detail if need be.