Forum Discussion
gmartineau
May 17, 2019Copper Contributor
Hire DAte add 30
I have a date cell (hire date) to which I need to add 30 days and then show the first of the month after that date. Not sure which formula to use.
- May 17, 2019
gmartineau , that could be
=EOMONTH(A1+30,0)+1
SergeiBaklan
May 17, 2019Diamond Contributor
gmartineau , that could be
=EOMONTH(A1+30,0)+1
- gmartineauMay 17, 2019Copper Contributor
SergeiBaklan that works perfectly. Thank you
- SergeiBaklanMay 17, 2019Diamond Contributor
gmartineau , you are welcome