Hey all,
I'm new to this forum and relatively inexperienced with Excel. I've learned a lot by brute force over the years, but this one has me stumped as I am honing my skills a little more each day. Finance and dates are a little different for me.
I would like a cell to display the next due date, based on a day of the month entered within the cell. For example, if a bill is to be paid on the 6th of each month, I would enter "6" but I would like it to display, 6FEB2021 (as of today). After the 6th of February, it would automatically change to 6MAR2021. Of course, it gets trickier at the end of the year, where after the 6th of December, the next due date will be 6JAN2022.
Ultimately, I want to be able to refer to this cell using conditional formatting to highlight green when a payment is made before the date, yellow if a payment is not made before the date, and red if the current date matches the next payment date. Everything I am doing right now for my finances is more of an experiment, as a I said to hone my skills, but I hope that the end result is a spreadsheet I can give my stepdaughter for her own finances in the future.
What is the best way of going about this? Will I need to create a table and use EDATE?
Thanks,
Matt in Norwich
Bookmarks