1
I have an excel sheet that lists our current due date. The due dates are the same day of each month (9/2, 10/2, etc) and I want the due date to update once the old date passes so I don't have to do this manually or have a column for each month. I am sure there is a formula to do this but nothing is working.
The formula pictured is what I have right now and I'm not sure why it isn't working - although even this I think we'll have a problem with after the December due date passes. Any ideas?
Looking for a non-VBA solution.
Very clever! +1 – Bandersnatch – 2017-09-27T23:52:09.073