+ Reply to Thread
Results 1 to 2 of 2

Formula To Calculate Month in a Previous Date

  1. #1
    Registered User
    Join Date
    01-07-2020
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Windows 7 Professional
    Posts
    1

    Formula To Calculate Month in a Previous Date

    Dear Sirs/Madams

    Please can you assist me with a formula.

    The current date is 30/11/2019 and I would like to determine the month (i.e. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11,12) based on this date minus 57 months.

    So 30/11/2019 minus 57 months gives me what month?

    Kind regards,

    Ben

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Formula To Calculate Month in a Previous Date

    =month(edate(a1,-b1))
    Ben Van Johnson

+ 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. Replies: 2
    Last Post: 06-01-2018, 03:33 AM
  2. [SOLVED] Formula to test if date is in the previous calendar month
    By kersplash in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2017, 09:31 PM
  3. [SOLVED] Dynamic formula to calculate the difference between current and previous month
    By kay007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2015, 11:19 AM
  4. [SOLVED] Formula issue for Current/Previous month Date
    By hecgroups in forum Excel General
    Replies: 3
    Last Post: 03-01-2014, 06:41 AM
  5. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  6. Replies: 4
    Last Post: 08-26-2010, 07:32 AM
  7. Auto calculate end date of previous month
    By BusterBoy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2009, 07:57 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