Need DATE formula

[Ron99]

=04-FEB-2025 ( today's date )
=31-MAR-2025 ( cut off date )

The cutoff date to do the next replenishment is 31-MAR-2025, If today's date go past 31-MAR-2025 the next cutoff date is 30-SEP-2025.
I have figured out the above formula, however replenishment needs to be done every year but at the same month and date. I would like a formula which only considers day & month ignoring the year.

Regards,
Ron

 

[Alex Blakenburg]

I am sure someone will come up with a shorter version but in the meantime see if this works for you.

20250204 Date 6 Monthly Cut Off Ron99.xlsx
	A	B
1	Test Date	Cut Off
2	04/02/2025	31/03/2025
3	12/10/2024	31/03/2025
4	21/09/2024	30/09/2024
5	10/09/2023	30/09/2023
6	05/12/2022	31/03/2023
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=IF(AND(MONTH($A2)<=9,MONTH($A2)>3), DATE(YEAR($A2),10,0), DATE(YEAR($A2)+IF(MONTH($A2)>8,1,0),4,0))

 

[Ron99]

Excellent!! perfectly works. Thank you.

 

[Peter_SSs]

I am sure someone will come up with a shorter version

I think this will do the same job.

25 02 04.xlsm
	A	B
1	Test Date	Cut Off
2	4/02/2025	31/03/2025
3	12/10/2024	31/03/2025
4	21/09/2024	30/09/2024
5	10/09/2023	30/09/2023
6	5/12/2022	31/03/2023
Cut Off

Cell Formulas
Range	Formula
B2:B6	B2	=EDATE(DATE(YEAR(A2),3,31),LOOKUP(MONTH(A2),{0,4,10},{0,6,12}))