+ Reply to Thread
Results 1 to 3 of 3

Given an end date find corresponding start date 3 months prior ..quarter date range

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,662

    Given an end date find corresponding start date 3 months prior ..quarter date range

    hi,

    I am trying to find / determine a start date based on an end date. The end date is always the end of a given month.

    Then what i want to do is go back 3 months to the begining of the 3rd month (see below):

    Start : End
    9/1/11 : 11/30/11
    8/1/11 : 10/31/11
    7/1/11 : 9/30/11
    6/1/11 : 8/31/11


    So you would be given the end date above and need to figure outthe corresponding start date............

    Anyone have any ideas?
    Last edited by welchs101; 01-04-2012 at 10:27 AM.

  2. #2
    Registered User
    Join Date
    12-30-2011
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Given an end date find corresponding start date 3 months prior ..quarter date ran

    Hi there,

    If your end date is in B1, try:

    =EOMONTH(B1,-3)+1

    HTH,

    Fermented R

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,443

    Re: Given an end date find corresponding start date 3 months prior ..quarter date ran

    Or, without the analysis toolpak, or XL2007

    =DATE(YEAR(A1),MONTH(A1)-2,1)
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ Reply to Thread

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