Forum Discussion

Sue_G's avatar
Sue_G
Brass Contributor
Jul 03, 2019

Excel End of Month Question

I want to be able to have Excel automatically add a date based on another set of data.  For example, we have a production date of 7/3/2019.  The shelf life in most cases is 4 years, but there are som...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 03, 2019

Sue_G 

That could be like

=EOMONTH(A1,12)+IF(DAY(EOMONTH(A1,12))>29,30,28)-DAY(EOMONTH(A1,12))

if we take 12th months period

 

Resources