Auto changing date in cell based on today’s date

[Allthingsezell]

I have a table full of my personal and business expenses. One column I have is “due date”. Like most bills, they are due on the same date each month.

I would like for excel to change the due date to the next monthes dues date based on whether that date has passed or not. For example: My power bill is due on 01/01/2025 and today’s date is 01/02/2025. I would like for excel to see that the power bill due date has passed and to change to next month, which would be 02/01/2025. How would I go about doing this?

 

[etaf]

how about
=IF(TODAY()>DATE(YEAR(TODAY()),MONTH(TODAY()),1),DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),DATE(YEAR(TODAY()),MONTH(TODAY()),1))

Not sure that will work , now looked at, as it will only be false on the 1st of the month

Book3
	A
1
2	4/1/25
3
Sheet1

Cell Formulas
Range	Formula
A2	A2	=IF(TODAY()>DATE(YEAR(TODAY()),MONTH(TODAY()),1),DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),DATE(YEAR(TODAY()),MONTH(TODAY()),1))