D6:
=IF(Table1[[#This Row],[Hire Date
Full-Time]]<>"",DATEDIF(Table1[[#This Row],[Hire Date
Full-Time]],TODAY(),"y"),"")
H6:
=IF(Table1[[#This Row],[Hire Date
Full-Time]]<>"",DATEDIF(Table1[[#This Row],[Hire Date
Full-Time]],TODAY(),"y"),"")
N6:
=IFERROR(LOOKUP(D6,{0,3,6},{80,120,160}),"")
O6:
=IFERROR(Table1[[#This Row],[Roll over]]+Table1[[#This Row],[Vacation hours
per Year]],"")
P6:
=IFERROR(Table1[[#This Row],[Accrued
Hours]]-Table1[[#This Row],[PTO
hours]],"")
Q6:
=IFERROR(FLOOR(IFERROR(Table1[[#This Row],[Vacation hours
per Year]]/52,""),1),"")
T6:
=IFERROR(Table1[[#This Row],[rate]]*Table1[[#This Row],[weeks]]+Table1[[#This Row],[Roll over]],"")
Bookmarks