Next June 1st

[xjohnson]

Hello,

I have a date in cell B2. How can I get the next future June 1st from that date and put that in C2?

Thank you ,
XJ

[dosydos]

try this in cell C2:

=TEXT(IF(MONTH(B2)>=6,DATE(YEAR(B2)+1,6,1),DATE(YEAR(B2),6,1)),"mm/dd/yyyy")

[xjohnson]

Thank you for the reply.

Is there a way to change that if I have a month in another cell? Sorry I forget to mention that.

[xjohnson]

I figured it out thanks so much for helping.

[dosydos]

Glad it worked and you were able to figure out how to change the month. thanks for the rep