+ Reply to Thread
Results 1 to 3 of 3

Get Today date minus 1 month

  1. 01-23-2021, 04:55 AM #1
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    927

    Get Today date minus 1 month

    Hey

    I am using =TODAY() To get today date
    How can I minus 1 month from the date? I don't want to minus 30 days =TODAY()-30

    Thanks
    Reply With QuoteRegister To Reply
  2. 01-23-2021, 05:01 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is online now
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,951

    Re: Get Today date minus 1 month

    Try this

    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    BSB
    Reply With QuoteRegister To Reply
  3. 01-23-2021, 05:03 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Get Today date minus 1 month

    =EDATE(TODAY(),-1)

    Check this handles dates like 30th March as you expect.
    Cheers
    Andy
    www.andypope.info
    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. [SOLVED] Today's date minus one day, except weekends. I.e Monday = Friday
    By goodquestionmma in forum Excel General
    Replies: 3
    Last Post: 01-13-2020, 11:43 AM
  2. [SOLVED] DATE minus TODAY formula
    By Kagesen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2018, 01:53 AM
  3. [SOLVED] Adding 4 days into the date today minus the weekend
    By geliedee in forum Excel General
    Replies: 5
    Last Post: 05-22-2015, 09:44 AM
  4. Autofill Date with =Today() function minus weekends.
    By slkenda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2013, 02:09 AM
  5. [SOLVED] If Statement with today's date minus due date for a delay calculation
    By RDFUC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 02:58 PM
  6. [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
  7. Today's date minus two
    By mldardy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2011, 11:51 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