Sick leave calculation

This is a discussion on Sick leave calculation within the Spreadsheets forums in Other Technologies category; Hey guys, I have tried a formula to count the sick leave taken but i realize that my formula is wrong b in my company the balance of my sick leave will be restarted each time the employee completes the year so i messed up please help this is the formula that i have used C=Starting Date and this is the sick leave schedule : 3months to 2 years:15 days 2 years tp 4 years :30 days 4 years to 6 years: 45 days 6 years to 10 years : 60 days =IF(TODAY()-C6>6*365,60,IF(TODAY()-...

Go Back   Database Forum > Other Technologies > Spreadsheets

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 03-19-2008, 05:58 AM
Default Sick leave calculation

Hey guys,

I have tried a formula to count the sick leave taken but i realize
that my formula is wrong b in my company the balance of my sick leave
will be restarted each time the employee completes the year so i
messed up

please help this is the formula that i have used

C=Starting Date

and this is the sick leave schedule :
3months to 2 years:15 days
2 years tp 4 years :30 days
4 years to 6 years: 45 days
6 years to 10 years : 60 days


=IF(TODAY()-C6>6*365,60,IF(TODAY()-C6>4*365,45,IF(TODAY()-
C6>2*365,30,IF(TODAY()-C6>0.25*365,15))))


please advise
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:16 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.