+ Reply to Thread
Results 1 to 2 of 2

Formula to calculate days, dates

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Australia
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit
    Posts
    57

    Formula to calculate days, dates

    To Whom It May Concern

    I want to create a formula that will return a date - eg 25 December 2014 - by simply typing in the current (today's) date.

    Let me give you an example of how I intend to use it.

    I am a certified Civil Marriage Celebrant (CMC), couple's who present before me requesting to be married, must present documentation (known as the) "Notice of Intended Marriage (NOIM)" to me according to the following criteria:

    The NOIM must be given to the authorised celebrant (me) no earlier than 18 months and no later than one month before the (intended) date of the marriage.

    Take the date of this message: 12 October 2014 (for future reference, this will be known as the "current date").

    So, where the formula is concerned, I want to be able to enter the current date and return the result (calculation) equaling the (see) example above.

    I trust this is easy to understand; if not, I'll try and simplify it, in response to any replies.

    Thank you.

    Matthew Hinds (Australia)

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Formula to calculate days, dates

    I think you want to use EDATE() for this. It will take a date (or cell) and add or subtract x-months from, that date

    So, using todays date (10/12/2014) in A1...
    =EDATE(A1,-18) = 4/12/2013
    =EDATE(A1,-1) = 9/12/2014
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. formula to calculate no of days from lastest dates
    By breadwinner in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-04-2013, 08:45 AM
  2. Replies: 1
    Last Post: 11-01-2012, 03:41 PM
  3. [SOLVED] formula to calculate # of days between dates, excluding holidays
    By abs2299 in forum Excel General
    Replies: 9
    Last Post: 10-11-2012, 03:59 AM
  4. Replies: 3
    Last Post: 05-03-2006, 05:15 PM
  5. Formula to calculate number of days between Dates
    By themax16 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-21-2005, 09:05 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