Return a text based on today's date (not considering year)

Hi there,

Struggling to build a straight forward formula to return a text based on a date, so I'm kindly asking your suggestion:

- if today is between the 29th of December until the 28th of April, return "28th April".
- if today is between the 29th of April until the 28th of July, return "28th July".
- if today is between the 29th of July until the 28th of October, return "28th October".
- if today is between the 29th of October until the 28th of December, return "28th December".

My main struggle to build this formula is because =today() also returns year, but this formula should not be based on the year, but only day and month.

Any suggestion?

Thanks!

Hi Glenn, thanks for your reply.

It doesn't work if the year is 2019 or greater.
Anything greater than 29/10/18 (for example, 01/01/2019) gets stuck in "28th December".

Any idea how to fix that?

Cheers

Or try:

=LOOKUP(MONTH(EDATE(A1-28,1)),{1,5,8,11},{"28th April","28th July","28th October","28th December"})

A1 =Today()