+ Reply to Thread
Results 1 to 3 of 3

Calculation of number based on current month

Hybrid View

  1. 02-23-2016, 06:28 AM #1
    roofi
    roofi is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    Calculation of number based on current month

    Dear All
    Please find attached sheet. my detailed question is in it.
    i need to calculate current number based on current month.
    ur support is required in this regard.

    Roofi
    Attached Files Attached Files
    Abdul Rouf Roofi
    Reply With QuoteRegister To Reply
  2. 02-23-2016, 06:32 AM #2
    excelfandoo
    excelfandoo is offline
    Registered User
    Join Date
    02-09-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Calculation of number based on current month

    Please try hlookup formula:

    =HLOOKUP(F4,$F$2:$Q$3,2,0)
    Reply With QuoteRegister To Reply
  3. 02-23-2016, 06:40 AM #3
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Calculation of number based on current month

    Or

    =INDEX(F3:Q3,MATCH($F$4,F2:Q2,0))

    Or

    =OFFSET($F$1,2,MATCH(F4,F2:Q2,0)-1)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    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. Running Average Based on Current number of days in month
    By dw_22801 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-22-2015, 12:48 PM
  2. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  3. [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
  4. VBA: Piviot table Month auto select based on current month?
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2013, 08:45 AM
  5. VBA: Piviot table Month auto select based on current month?
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2013, 07:18 AM
  6. [SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period
    By jeversf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 12:10 PM
  7. Using month in calculation ONLY if current year is 2009.
    By wublub in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2008, 06:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1