Here is my conundrum....
In my current bill pay spreadsheet I have a due date column EXD) I then have a column for every month EXJan, Feb ,Mar etc) each of these months is followed by a Paid column (R, T, V, x). I would like to see the month portion of the date change EX: from 7/13/2009 to 8/13/2009 when paid column data is entered. Any suggestions?
In my current bill pay spreadsheet I have a due date column EXD) I then have a column for every month EXJan, Feb ,Mar etc) each of these months is followed by a Paid column (R, T, V, x). I would like to see the month portion of the date change EX: from 7/13/2009 to 8/13/2009 when paid column data is entered. Any suggestions?