I need a formula to calculate the number of hours earned based on the years and months of service. k5 contains the years of service in years and months. ie. 4 years, 2 months
=IF(TODAY()>=DATE(2015,2,1),IF(AND(k5<=4,S7>=0),8,IF(AND(k5>=5,k5<=9),10,IF(AND(k5>=10),12))))
hi eminter,
can you upload a sample of your workbook? this request is confusing without it.
what is the point of your first if statement "if(today()>-date(2015,2,1)... you already know today is greater than 2/1/2015, what's the point of performing that check?
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
What is the start date?
Spread the love, add to the Rep
"None of us are as smart as all of us."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks