+ Reply to Thread
Results 1 to 3 of 3

Formula to calculte previous month name from current month selected

  1. #1
    Forum Contributor
    Join Date
    09-19-2018
    Location
    England
    MS-Off Ver
    O365
    Posts
    266

    Formula to calculte previous month name from current month selected

    Morning all

    I have a data validation drop down which is by month.

    What I am looking to do is have a formula that once a month is selected from D5 to show the previous month name in D20

    Is this possible so no matter what month you select in the drop down of D5 below automatically in D20 the previous months name will be shown.

    I have attached an example, cheers
    Attached Files Attached Files
    Last edited by MattExcelLearner; 07-22-2020 at 04:32 AM.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Formula to calculte previous month name from current month selected

    you could use:

    D20:
    =TEXT(EOMONTH(1&D5,-1),"mmm")

  3. #3
    Forum Contributor
    Join Date
    09-19-2018
    Location
    England
    MS-Off Ver
    O365
    Posts
    266

    Re: Formula to calculte previous month name from current month selected

    Awesome that worked

    Many thanks lent

+ 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. [SOLVED] Need formula to calculate days used in month initiated in previous and selected month
    By Ochimus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2021, 05:54 AM
  2. VBA code adjustment to include only current month and previous month automatically.
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2015, 03:02 PM
  3. [SOLVED] Formula for amount on previous month based on current month
    By Yu Marquez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-21-2014, 12:42 AM
  4. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  5. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  6. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  7. [SOLVED] copy worksheet from previous month and rename to current month
    By Dan E. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2005, 05:45 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