+ Reply to Thread
Results 1 to 6 of 6

Current Month Number

Hybrid View

vill Current Month Number 01-30-2018, 11:09 AM
samba_ravi Re: Current Month Number 01-30-2018, 11:21 AM
Jonmo1 Re: Current Month Number 01-30-2018, 11:29 AM
AlKey Re: Current Month Number 01-30-2018, 11:41 AM
vill Re: Current Month Number 01-30-2018, 11:56 AM
Jonmo1 Re: Current Month Number 01-30-2018, 12:57 PM
  1. 01-30-2018, 11:09 AM #1
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Current Month Number

    Hi guys, would you know the answer to this one? Please see a screenshot and Excel attached.

    Thanking in advance.

    https://www.excelforum.com/attachmen...1&d=1517324943 [EXCEL]

    2018-01-30_1705.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-30-2018, 11:21 AM #2
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Current Month Number

    TRY
    =INDEX(C6:N6,MATCH(TEXT(TODAY(),"mmmm"),INDEX(TEXT(C7:N7,"MMMM"),0),0))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 01-30-2018, 11:29 AM #3
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Current Month Number

    Perhaps

    =MONTH(EDATE(TODAY(),-3))
    Reply With QuoteRegister To Reply
  4. 01-30-2018, 11:41 AM #4
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Current Month Number

    Or this
    Formula: copy to clipboard 
    =INDEX(C6:N6,MATCH(MONTH(TODAY()),INDEX(MONTH(C7:N7),0),0))
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  5. 01-30-2018, 11:56 AM #5
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Current Month Number

    Awesome work, thank you guys!!
    Reply With QuoteRegister To Reply
  6. 01-30-2018, 12:57 PM #6
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Current Month Number

    You're welcome.
    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. total of days within current month with dates from before the current month and year
    By ozinal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2016, 01:28 PM
  2. [SOLVED] Calculation of number based on current month
    By roofi in forum Excel General
    Replies: 2
    Last Post: 02-23-2016, 06:40 AM
  3. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  4. [SOLVED] Pick a cell containing current month actulas based what the current month is.
    By vanbasten007 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2014, 01:17 AM
  5. [SOLVED] Find max number of current month.
    By v!ctor in forum Excel General
    Replies: 4
    Last Post: 09-29-2012, 01:25 PM
  6. Number of Mondays left in current month
    By JuJuBe in forum Excel General
    Replies: 3
    Last Post: 09-20-2010, 06:51 PM
  7. Show week number in current month
    By DKerr in forum Excel General
    Replies: 4
    Last Post: 02-23-2006, 05:25 PM

Tags for this Thread

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