+ Reply to Thread
Results 1 to 11 of 11

Leave accrual in an FY

  1. 08-13-2018, 12:31 AM #1
    sheetnoob
    sheetnoob is offline
    Registered User
    Join Date
    08-12-2018
    Location
    hawaii
    MS-Off Ver
    365
    Posts
    7

    Leave accrual in an FY

    I am trying to calculate the projected days of leave/vacation in a standard US fiscal year(october to october).

    given:

    current days/days scheduled for use/ accrual rate 2.5 per month/

    EX:
    (current month July)
    CD SD projected end of FY
    35 2 38

    its super simple but i know but I'm stuck
    Reply With QuoteRegister To Reply
  2. 08-13-2018, 12:59 AM #2
    jme1013
    jme1013 is offline
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: Leave accrual in an FY

    I'm not sure exactly what you're looking for.

    Are you looking to have a formula or excel sheet that keeps track of your vacation days based on how many you've already used, scheduled, and your accrual rate?

    It's better if you attach an example excel file with what you're wanting to accomplish.

    Just make it look like what you are wanting the results to be. It doesn't need to be functional.
    Reply With QuoteRegister To Reply
  3. 08-13-2018, 01:41 AM #3
    sheetnoob
    sheetnoob is offline
    Registered User
    Join Date
    08-12-2018
    Location
    hawaii
    MS-Off Ver
    365
    Posts
    7

    Re: Leave accrual in an FY

    I attached an excel with what I'm looking for, thre is a formula included that i think gets the idea of what my goal is i cant figure out the verbiage.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-13-2018, 01:47 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Leave accrual in an FY

    What are you expecting MONTH to return?

    What we need to know is your expected result in that cell.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 08-13-2018, 01:48 AM #5
    samba_ravi
    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,914

    Re: Leave accrual in an FY

    may be
    =A3-B3+2.5*(MONTH(G2)-1)
    or
    =A3-B3+2.5*MONTH(G2)
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  6. 08-13-2018, 01:55 AM #6
    sheetnoob
    sheetnoob is offline
    Registered User
    Join Date
    08-12-2018
    Location
    hawaii
    MS-Off Ver
    365
    Posts
    7

    Re: Leave accrual in an FY

    i need it to multiply the number of months from october by 2.5.

    i.e. : august-october= 2
    Reply With QuoteRegister To Reply
  7. 08-13-2018, 02:17 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Leave accrual in an FY

    Is this what you want?

    =SUM((A3-B3)+(2.5*(MONTH("01/10/2018")-MONTH(G2))))
    Reply With QuoteRegister To Reply
  8. 08-13-2018, 02:26 AM #8
    sheetnoob
    sheetnoob is offline
    Registered User
    Join Date
    08-12-2018
    Location
    hawaii
    MS-Off Ver
    365
    Posts
    7

    Re: Leave accrual in an FY

    I think this will work.

    Thank you
    Reply With QuoteRegister To Reply
  9. 08-13-2018, 02:34 AM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Leave accrual in an FY

    You're welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  10. 08-13-2018, 02:57 AM #10
    sheetnoob
    sheetnoob is offline
    Registered User
    Join Date
    08-12-2018
    Location
    hawaii
    MS-Off Ver
    365
    Posts
    7

    Re: Leave accrual in an FY

    One more related follow up question and ill be golden. I did some fiddling and i looked around and i cant find anything. i need the month values to correspond to a fiscal year instead of a calendar year. October being the 1st month. oct=1,nov=2,dec=3...september=12

    please see attached. G2&H2
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 08-13-2018, 03:02 AM #11
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Leave accrual in an FY

    This is a different query - start a new thread with an appropriate title, please. This thread should be marked 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. [SOLVED] Calculating Employee Leave Accrual
    By pknivens1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-02-2016, 10:50 AM
  2. [SOLVED] FMLA Leave plus sick and vacation accrual calculator
    By BrotherNeptune in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2015, 10:55 AM
  3. Spreadsheet for vacation accrual that can borrow against future potential accrual
    By strong42 in forum Excel General
    Replies: 4
    Last Post: 01-20-2015, 11:51 AM
  4. Assistance with Accrual and daily sick leave balances
    By JuanitaS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2014, 08:06 AM
  5. Vacation and Sick Leave Accrual formula
    By Dowjd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2013, 10:24 PM
  6. Leave Accrual Spread sheet
    By Luphai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2013, 08:40 AM
  7. Annual leave accrual formula
    By Lebogang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2012, 07:56 AM

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