+ Reply to Thread
Results 1 to 3 of 3

How to Calculate actual date when starting date and months is given?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office 365
    Posts
    57

    How to Calculate actual date when starting date and months is given?

    I have a series of starting date starting from year 2012 till 2014, and the period given is 54 months, how to calculate actual date after 54 months?

    As below example:
    Starting date: 23/4/2013

    Period : 54 months

    Actual date after 54 months is ?

    For the 48 months i can calculate manually the days either is 365 or 366 but the balance 6 months is subject to the starting date fall under which month.
    I need to calculate the accurate date from each starting date.
    Please help and thank you.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: How to Calculate actual date when starting date and months is given?

    You can try the EDATE function.

    E.g., if you have the date (23/4/2013) in cell A1, you can use the formula
    Formula: copy to clipboard
    =EDATE(A1,54)

    which should give you 23/10/2017.

  3. #3
    Registered User
    Join Date
    08-04-2015
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office 365
    Posts
    57

    Re: How to Calculate actual date when starting date and months is given?

    Thank you. This is the formula i looking at.

+ 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. [SOLVED] Amount of years/months from starting date until today
    By Onesock in forum Excel General
    Replies: 3
    Last Post: 03-06-2015, 07:45 AM
  2. [SOLVED] Calculate end date base don Start date + 6 months
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2013, 02:20 PM
  3. [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
  4. Calculate Date Six Months from Cell Date, ongoing
    By OZover in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-17-2010, 09:13 AM
  5. Calculate due date from a starting day
    By Yves in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2006, 07:10 AM
  6. calculate date differences in years and months
    By Joyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2005, 02:06 PM
  7. [SOLVED] How do I calculate interest on actual date?
    By cgourlay in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-18-2005, 02:06 AM

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