+ Reply to Thread
Results 1 to 5 of 5

Calculate next due date based on start date frequency and current date

  1. #1
    Registered User
    Join Date
    01-26-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2007/10
    Posts
    5

    Calculate next due date based on start date frequency and current date

    Hi there,

    I'm trying to workout how to take a known initial date a repeating frequency and work out the next due date from today.

    Example

    Initial Date :- 1st of January 2014

    Frequency :- every 5 weeks

    Current Date :- 9th of March 2014

    Next Due date should be :-12th of March 2014 (if I worked it out correctly from my paper calendar)

    I want to use a cell formula to do this for different initial dates and varying frequency periods (the frequency will always be whole weeks i.e. 1,2,3,4,5,6,7,8,8,10)

    Regards

    Ironoverload

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,085

    Re: Calculate next due date based on start date frequency and current date

    Hi, ironoverload,

    maybe a comibation of Data/Validation, Firumlas and Conditional Formatting:
    week number is in B1
    Formula in A2 (drag down as wide as necessary)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Ciao,
    Holger
    Attached Files Attached Files
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    01-26-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2007/10
    Posts
    5

    Re: Calculate next due date based on start date frequency and current date

    Hi Holger,

    This is great, but I'm only interested in the next due date from this week.
    So if I open the spreadsheet today 9th March 2014 and the initial date (1st Jan 2014) is in A1 for this particular repeating task and the frequency is in A2 as (7) then if the Next due date is in A3 it will be (12th of March).

    That way if I drag the formula down all of my tasks with different initial dates and frequencies I will only see all of the immediate Next Due dates after Today and not the next after and so on.

    Regards

    Ironoverload

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,085

    Re: Calculate next due date based on start date frequency and current date

    Hi, ironoverload,

    A1 holds the startdate, A2 the actual/today´s date, B1 the number of weeks.

    Formula for A3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and format A3 as Date.

    Ciao,
    Holger

  5. #5
    Registered User
    Join Date
    01-26-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2007/10
    Posts
    5

    Re: Calculate next due date based on start date frequency and current date

    Holger,

    Tremendous works a treat

    Many thanks

    Ironoverload

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-21-2013, 12:22 PM
  2. [SOLVED] Calculate date based on number of weeks or months after start date
    By wotsup in forum Excel General
    Replies: 3
    Last Post: 08-17-2012, 06:00 AM
  3. Calculate START date based on duration (work hours) and END date
    By kaaver in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-06-2010, 12:21 PM
  4. Calculate start date based on working hours and end date
    By kaaver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2010, 06:58 AM
  5. [SOLVED] VBA that automatically generates a series of cash flows based on a start date, an end date and frequency
    By tamzik@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-27-2005, 06:10 PM

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