The Naked Scientists

The Naked Scientists Forum

Author Topic: How do I automatically insert a rolling date into an Excel spreadsheet?  (Read 3360 times)

Offline arbloch

  • First timers
  • *
  • Posts: 1
    • View Profile
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?
« Last Edit: 04/07/2015 11:46:51 by chris »


 

Offline nicephotog

  • Sr. Member
  • ****
  • Posts: 387
  • Thanked: 7 times
  • H h H h H h H h H h
    • View Profile
    • Freeware Downloads
Re: Excel Formula...
« Reply #1 on: 04/07/2015 11:21:09 »
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.
 

The Naked Scientists Forum

Re: Excel Formula...
« Reply #1 on: 04/07/2015 11:21:09 »

 

SMF 2.0.10 | SMF © 2015, Simple Machines
SMFAds for Free Forums