Results 1 to 20 of 20

How To Calculate future dates from start date on a monthly cycle

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    How To Calculate future dates from start date on a monthly cycle

    I'm trying to combine monthly calculations with "today" and with "workdays"


    Example:

    start date = 01/01/2009

    today's date 09/16/2009

    formula result = 10/01/2009 ; or if 10/01/2009 is a Sunday, result = 09/29/2009 (not 02/01/2009, 03/01/2009, etc)

    =edate gives me a month but it doesn't skip weekends or calculate beyond today's date
    Last edited by HOWTOEXCEL; 09-16-2009 at 05:43 PM. Reason: SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1