+ Reply to Thread
Results 1 to 9 of 9

How to calculate 13th month

  1. 04-22-2014, 04:05 AM #1
    Santhoshhrishi
    Santhoshhrishi is offline
    Registered User
    Join Date
    03-10-2014
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    24

    How to calculate 13th month

    Hi Team,

    I am stuck with this. Request someone to help me on this reg. I need to calculate 13th month for certain payout based on DOJ of certain employees. If I keep on adding emps with DOJ will any formula will help in throwing 13th month automatically. Pls help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-22-2014, 04:22 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How to calculate 13th month

    Hi

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

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 04-22-2014, 04:30 AM #3
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: How to calculate 13th month

    Hi,

    You can use the following formula in D2

    =EOMONTH(C2,12)
    Reply With QuoteRegister To Reply
  4. 04-22-2014, 05:25 AM #4
    Santhoshhrishi
    Santhoshhrishi is offline
    Registered User
    Join Date
    03-10-2014
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: How to calculate 13th month

    Many thanks fotis & cbatrody!! This works.
    Reply With QuoteRegister To Reply
  5. 04-29-2014, 08:24 AM #5
    Santhoshhrishi
    Santhoshhrishi is offline
    Registered User
    Join Date
    03-10-2014
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: How to calculate 13th month

    Team,

    Sorry, I missed to highlight one more logic.

    "Anyone who had joined before 1-July 2013, payout month will be 31-July-2014" & joinees after 1-july 2013 payout will be on 13th month from DOJ."

    How to incorporate this logic with a formula. Please help.

    Attached file fyr.,

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-29-2014, 08:33 AM #6
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to calculate 13th month

    Try

    =MAX(DATE(2014,7,31),EOMONTH(C2,12))
    or
    =MAX("31/7/14",EOMONTH(C2,12))
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  7. 04-29-2014, 08:34 AM #7
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: How to calculate 13th month

    Hi,

    Please check the attached template. I have modified the formula now.





    Please click on ‘* Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 02-01-2019, 10:13 AM #8
    aojelade
    aojelade is offline
    Registered User
    Join Date
    02-01-2019
    Location
    LAGOS
    MS-Off Ver
    O365
    Posts
    1

    Re: How to calculate 13th month

    Is there a standard sheet to calculate 13th Month ???
    Reply With QuoteRegister To Reply
  9. 03-01-2019, 08:57 PM #9
    mandane
    mandane is offline
    Registered User
    Join Date
    03-01-2019
    Location
    philippines
    MS-Off Ver
    ms 2013
    Posts
    1

    Thumbs up Re: How to calculate 13th month

    Thanks useful thread!
    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] Lookup month and calculate if specific month value apply
    By D-smoke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-24-2013, 03:03 AM
  2. [SOLVED] calculate pay checks per month, to get monthly income value for that month.
    By tladd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2012, 09:51 PM
  3. deleting every 13th row in excel sheet
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-05-2012, 12:18 PM
  4. [SOLVED] Sum function that add every 13th row...
    By Greg in forum Excel General
    Replies: 9
    Last Post: 03-08-2006, 03:10 PM
  5. using auto fill, but need to skip every 13th number
    By gotzoom in forum Excel General
    Replies: 3
    Last Post: 01-19-2006, 10:35 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