ExcelBanter - Annual leave

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Annual leave (https://www.excelbanter.com/excel-discussion-misc-queries/179753-annual-leave.html)

Annual leave

Hey Guys, i am trying to find a formula that calculates the number of
annual leave allowed pr year and i cant find find it

houghi

Annual leave

wrote:
Hey Guys, i am trying to find a formula that calculates the number of
annual leave allowed pr year and i cant find find it

That probably depends on several factors. So what do you already have?
What is it based on? e.g. in Belgium it depends on the comapny. 22 is
about normal. Next it depends on the number of days worked the previous
year.

So if you have worked a whole year last year, you will have 22 days this
year. If you worked 6 months, you will have 11. Howver if you worked at
another company, the days of THAT company will count.

So if you have worked 6 months for the current company it will give you
11 days. If you have worked at another company where the standard is 24
instead of 22, you will get 12 more. So you will have 23 in total
instead of 22.

Also it depends on wether you got them payed instead or if you have some
days left.

So at least in Belgium, because you need the data of another company, it
is basicaly a fixed number that is provided to each HR department.
Calculations can only be done if you have full details of all the
companies people worked in the previous year.

houghi
--
You tried, and you failed, so the lesson is, never try. - Homer J. Simpson.

Jim Cone

Annual leave

You might try the company handbook.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

wrote in message
Hey Guys, i am trying to find a formula that calculates the number of
annual leave allowed pr year and i cant find find it

Arup C[_2_]

Annual leave

Hi Tia,
you can try "=SUMPRODUCT(--(WEEKDAY(range)=1))" though it will calculate
only the sundays you can give your range of cells which contains the dates of
the year 1 represents the first day (sunday) of week.

" wrote:

Hey Guys, i am trying to find a formula that calculates the number of
annual leave allowed pr year and i cant find find it

All times are GMT +1. The time now is 06:57 AM.