Formula to change the date in a cell based on the date in another cell

[BoggleJ]

I have a drop down list of the 1st of the month for every month from the beginning of this year through 2029. I need a formula that checks what date is in the cell where my drop down is and sets the value of the cell this formula is in to the 1st of the next month and and year if it rolls over like if the drop down contains December 1st of any year. Keep in mind this is not to auto generate several months just always set it to the 1st of the next month.

 

[Joe4]

You can use the EDATE function, i.e.

=EDATE(A2,1)

 

[Fluff]

How about

=EDATE(A2,1)

 

[BoggleJ]

Thank you I knew something like that existed but I couldn't find it.

 

[Joe4]

You are welcome.
Glad we were able to help!