Results 1 to 9 of 9

Thread: Help Please

  1. #1

    Help Please



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have 10 staff and need to organise a spreadsheet showing their leave entitlement.

    Everyone's leave starts on 1 Jan, is there a formula I can use so that it automatically adds accrued leave at the rate of 1.8 days on the first of every month

    EG: On 1st Jan it should show 1.8 days then on 1st Feb it automatically changes to 3.6 then on 1 Mar it should change again to 5.4 etc, etc

    Thank you

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,678
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Without seeing the layout it's difficult to give an exact answer.
    But you could try something like =MONTH(TODAY())*1.8
    Thank you Ken for this secure forum.

  3. #3
    I'll give it a go.
    This is a really basic spreadsheet with names in First column. Second column is Accrued leave. I'd like to make each person's accrued cell update automatically by 1.8 days on first of every month in case I forget to do it manually.
    I know this is trivial compared to the other stuff on the forum but all help Will be gratefully received.
    Thank you

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    Just upload a file - much easier than trying to describe it!
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    All help gratefully received.

    I'd like column B to go up by 1.8 days on 1st of every month automatically

    Thank you
    Attached Files Attached Files

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,678
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Have you tried my suggestion? It will of course work only if everybody begins in January.
    Otherwise you will have to add a column with the date they started.
    If so, you must determine if someone beginning between the 1st and the last day of the month also gets 1.8 days..
    Thank you Ken for this secure forum.

  7. #7
    I've tried it. Not sure it's working correctly. Everyone's accrued leave starts on 1 Jan regardless of when they started because they are existing staff, I know I'll need to play about with it when we have someone join the company in April but wanted to get it correct for existing staff first.

    I don't read "formula" so, does your suggestion mean it adds 1.8 days on the first of every month?

  8. #8
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,678
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Let's see :
    TODAY() returns today's date
    MONTH(Today()) will return a number from 1 to 12
    So, in say, January, MONTH.. will always return 1
    1*1.8 = 1.8
    Starting February, MONTH... returns 2, and the formula 2*1.8=3.6,etc...
    If you enter the formula for your employees today it should return 3.6 for everybody
    Thank you Ken for this secure forum.

  9. #9
    Pecoflyer. Thank you so much. Will give it a go. Northwood

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •