+ Reply to Thread
Results 1 to 5 of 5

subtract 3 calendar months from today's date

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    tacoma, wa
    MS-Off Ver
    excel 2010
    Posts
    53

    subtract 3 calendar months from today's date

    This is a stupid easy problem I'm sure but I need help.

    I have =Month(Today()) which gives me "1" for January.

    but I am looking at a 3 month window behind me that shifts with each current month. so if it's January I am looking at Oct - Dec. so if today is 1 for January I actually need it to display 10 for October.

    I have accomplished this by using =Month(Today()-90) but I fear that it may eventually display the wrong data because not every month has 30 days.

    When I use =Month(Today())-4 it gives me "-3" which isn't helpful and when I place it inside the () it still gives me a "1" which also doesn't help.

    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: subtract 3 calendar months from today's date

    try:

    =MONTH(DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())))
    If I've helped U pls click on d *Add Reputation

  3. #3
    Registered User
    Join Date
    08-02-2013
    Location
    tacoma, wa
    MS-Off Ver
    excel 2010
    Posts
    53

    Re: subtract 3 calendar months from today's date

    wow, guess it wasn't "stupid easy"

    but that worked. Thank you sir.

  4. #4
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: subtract 3 calendar months from today's date

    You're welcome. Glad to help. Thanks for the rep

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: subtract 3 calendar months from today's date

    To be more accurate you would use the EDATE function.

    =MONTH(EDATE(NOW(),-3))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Add 12 months to a date and then subtract TODAY()
    By ScottWilliams324 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2014, 09:57 PM
  2. [SOLVED] Creating a view by filtering 2 columns by date (both within 3 months of today's date)
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-21-2014, 05:04 AM
  3. [SOLVED] How to get the date of 3 months ago from today?
    By billj in forum Excel General
    Replies: 5
    Last Post: 08-30-2013, 07:06 AM
  4. [SOLVED] Excel Macro: Ask user for date then subtract 6 months from it
    By foxy_420 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2013, 11:09 AM
  5. Replies: 15
    Last Post: 06-26-2012, 07:28 AM
  6. [SOLVED] Show today's date on calendar
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 04:23 PM
  7. [SOLVED] How do I subtract today's date from one before 1900?
    By Bob Martin in forum Excel General
    Replies: 3
    Last Post: 10-12-2005, 08:05 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