ExcelBanter - How to use month() and day() without considering year()?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to use month() and day() without considering year()? (https://www.excelbanter.com/excel-discussion-misc-queries/69320-how-use-month-day-without-considering-year.html)

Eric

How to use month() and day() without considering year()?

I would like to determine whether today is within a period or not, such as
Is today between 1-Mar and 1-Apr without considering year?
Does anyone know how to do it?
Thank for any suggestion
Eric

How to use month() and day() without considering year()?

See reply in worksheet functions - and please don't multipost.

"Eric" wrote in message
...
I would like to determine whether today is within a period or not, such as
Is today between 1-Mar and 1-Apr without considering year?
Does anyone know how to do it?
Thank for any suggestion
Eric

All times are GMT +1. The time now is 11:06 AM.