Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Annual leave monthly calculation
hi
I have made an exel sheet to calculate the vacation leave for all the employees and i have used this formula C7=starting date =IF(TODAY()-C710*365,19,IF(TODAY()-C75*365,17,IF(TODAY()- C70.25*365,15))) But what i really need is to calculate their leave on monthly basis b there is too much fractions in the total Please advise Tia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Annual leave monthly calculation
If you want to calculate date differences by month, use the DATEDIF
function: http://www.cpearson.com/excel/datedif.htm -- David Biddulph "Tia" wrote in message ... hi I have made an exel sheet to calculate the vacation leave for all the employees and i have used this formula C7=starting date =IF(TODAY()-C710*365,19,IF(TODAY()-C75*365,17,IF(TODAY()- C70.25*365,15))) But what i really need is to calculate their leave on monthly basis b there is too much fractions in the total Please advise Tia |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Annual leave monthly calculation
So, they are entitled to 19 days leave if they have worked for more than 10
years, 17 days if more than 5 years, and 15 days if more than 0.25 years? All you need to do to get the per-month days is to divide 19, 17 and 15 by 12 in your formula. Then you can multiply this by the number of months since the start of the year. Hope this helps. Pete "Tia" wrote in message ... hi I have made an exel sheet to calculate the vacation leave for all the employees and i have used this formula C7=starting date =IF(TODAY()-C710*365,19,IF(TODAY()-C75*365,17,IF(TODAY()- C70.25*365,15))) But what i really need is to calculate their leave on monthly basis b there is too much fractions in the total Please advise Tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annual leave without holidays | Excel Discussion (Misc queries) | |||
Annual leave | Excel Discussion (Misc queries) | |||
Annual Leave Planner | Excel Discussion (Misc queries) | |||
Annual Leave | Excel Discussion (Misc queries) | |||
Tracking annual leave | New Users to Excel |