aribroo

Q: Returning date from next Monday

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 Oct10/26
(Monday) 26 Oct10/26
(Tuesday) 27 Oct11/2
(Wednesday) 28 Oct11/2
(Thursday) 29 Oct11/2
(Friday) 30 Oct11/2
(Saturday) 31 Oct11/2

Posted on Oct 27, 2015 12:05 PM