[arbloch (OP)]

Hey all. I'm dumping way too much time at work into making this spreadsheet because, you know, spreadsheets are really cool and stuff. One formula has me stumped, though, and Google doesn't know either (I think).

What I want to do is have an automatically rolling date so that client X's next due date jumps forward one month after the date passes. So, for example, today is 5/15/2015. Say his bill is due 5/16/2015. Right now I want the field to read 5/16/2015, but on May 17th I want Excel to automatically update to the same day the following month (6/16/2015). Anyone know how to do this?

[nicephotog]

Do you mean this type of thing?
http://windowsitpro.com/scripting/scripting-solutions-wsh-and-com-automating-reports-outlook-and-excel
http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/

You need "windows script host" (WSH) installed your Win OS , it usually is but just check "windows components" to be sure, and also get "Power Shell" from MSDN downloads.