ExcelBanter - formular to change data on a certain date every month

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formular to change data on a certain date every month (https://www.excelbanter.com/excel-programming/319725-formular-change-data-certain-date-every-month.html)

the keyholder

formular to change data on a certain date every month

I need a formular to change data on a certain date every month so that on the
1st of every month a cell value will decrease. say from 48 to 47 and so on.
Any feedback would be greatfull. Thanks

All times are GMT +1. The time now is 09:45 AM.