SOLVED

Hire DAte add 30

Copper Contributor

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.

3 Replies
best response confirmed by gmartineau (Copper Contributor)
Solution

@gmartineau , that could be

=EOMONTH(A1+30,0)+1

@Sergei Baklan that works perfectly.  Thank you

@gmartineau , you are welcome

1 best response

Accepted Solutions
best response confirmed by gmartineau (Copper Contributor)
Solution

@gmartineau , that could be

=EOMONTH(A1+30,0)+1

View solution in original post