Hi Excel wizards,
I have a date formula that is working in all ways except near year-end, when instead of rolling to the next year, it rolls back to the current year. I feel like I'm just missing one small part of the formula, but can't figure it out. Any help appreciated. Thank you!
Formula in cell I2 of the image is as follows: =DATE(YEAR([@[ES_ETA]]), MONTH(EOMONTH([@[ES_ETA]], (DAY([@[ES_ETA]])>25)+1)),1)
I have a date formula that is working in all ways except near year-end, when instead of rolling to the next year, it rolls back to the current year. I feel like I'm just missing one small part of the formula, but can't figure it out. Any help appreciated. Thank you!
Formula in cell I2 of the image is as follows: =DATE(YEAR([@[ES_ETA]]), MONTH(EOMONTH([@[ES_ETA]], (DAY([@[ES_ETA]])>25)+1)),1)