I'm trying to get my budget to show when a bill is next due, and I want to have this updated dynamically (I think I'd use the =TODAY() function for this, but I can't figure out the pieces.) The bill is due each Monday, and I want it to be returned in either M/DD/YYYY or MM/DD format.
| If I were to open the spreadsheet on... | I would see... |
|---|
| BILL: DUE DATE |
| (Sunday) 25 Oct | 10/26 |
| (Monday) 26 Oct | 10/26 |
| (Tuesday) 27 Oct | 11/2 |
| (Wednesday) 28 Oct | 11/2 |
| (Thursday) 29 Oct | 11/2 |
| (Friday) 30 Oct | 11/2 |
| (Saturday) 31 Oct | 11/2 |