Excel Formula - Find the next April from todays date

[The Great SrH]

Hi guys,

I was wondering if anybody could help me with a formula to find the next April from Today's date?


I've tried searching but I can't find a thing!


Thanks in advance

 

[Fluff]

How about
=IF(MONTH(TODAY()+1)=4,TODAY()+1,DATE(YEAR(TODAY())+1,4,1))

 

[AlanY]

how about?

="April "&IF(MONTH(TODAY())<4,YEAR(TODAY()),YEAR(TODAY())+1)

 

[The Great SrH]

Amazing - thanks both!

 

[AlanY]

you're welcome

 

[Fluff]

Glad to help & thanks for the feedback