Formula Numeric Field
Looking for some help with a formula for a Formula Numeric field. So we give full-time employees 14 paid days off per year. So if they work the full year it is easy to calculate how many days off ...
Forum Discussion
Wanted to see if you had a solution after I provided the additional info. Thank you in advance!
Mark
------------------------------
Mark Comish
------------------------------
Mark
------------------------------
Mark Comish
------------------------------
Try this:
I briefly tested it and it looks like it's working correctly.
------------------------------
-Tom
------------------------------
If([start date]<FirstDayOfYear(Today()),14-[Days Used],Round((If(IsLeapYear([start date]),366,365)-DayOfYear([start date])-1)/If(IsLeapYear([start date]),366,365)*14,0.5)-[Days Used])I briefly tested it and it looks like it's working correctly.
------------------------------
-Tom
------------------------------
- Thank you very much Tom!
------------------------------
Mark Comish
------------------------------