=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
=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