+ Reply to Thread
Results 1 to 6 of 6

Date minus 6 month

  1. 02-29-2016, 08:44 AM #1
    dougers1
    dougers1 is offline
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    Date minus 6 month

    Hi how do I get to show a date that is 6 month subtracted Dom current date
    Cell a1 has =TODAY()
    Cell a2 I want current date minus 6 month

    Thanks
    Reply With QuoteRegister To Reply
  2. 02-29-2016, 08:49 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Date minus 6 month

    in A2=EDATE(A1,-6)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 02-29-2016, 08:50 AM #3
    mdimran.ahmed30
    mdimran.ahmed30 is offline
    Registered User
    Join Date
    12-07-2015
    Location
    delhi
    MS-Off Ver
    2010
    Posts
    80

    Re: Date minus 6 month

    Hi,

    You can use this function.

    =EOMONTH(A1,-6)

    when A1 is today date then you can put formula on the cell B1.
    Reply With QuoteRegister To Reply
  4. 02-29-2016, 09:19 AM #4
    dougers1
    dougers1 is offline
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429
    Quote Originally Posted by Special-K View Post
    in A2=EDATE(A1,-6)
    Thanks guys
    Reply With QuoteRegister To Reply
  5. 03-09-2016, 07:41 AM #5
    dougers1
    dougers1 is offline
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    Re: Date minus 6 month

    how do i get it to show minus 6 month and a day.
    Reply With QuoteRegister To Reply
  6. 03-09-2016, 07:42 AM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Date minus 6 month

    Maybe this...

    =EDATE(A1,-6)-1
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. YTD Total Minus Previous Month
    By Emily2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2014, 01:44 PM
  2. [SOLVED] VBA Current Month Minus 1
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-12-2013, 08:03 AM
  3. [SOLVED] need help to lookup a (workday) date, and then excel output to show that date minus 1
    By Marijke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2013, 11:13 AM
  4. [SOLVED] Macros for: If Today's Date minus other date is greater than certain amount of days Then
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-24-2012, 04:46 PM
  5. Todays date minus 1 month
    By Newton1234 in forum Excel General
    Replies: 8
    Last Post: 11-20-2008, 01:28 PM
  6. [SOLVED] DATE & MONTH minus ?
    By Tufail in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2006, 12:55 PM
  7. [SOLVED] Formula for current month minus one = Quarter number in a macro.
    By Pank in forum Excel General
    Replies: 11
    Last Post: 06-22-2005, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1