Question: table [ [ table [ [ = today ( ) ] , [ = days 3 6 0 ( start date, end date
tabletable today days start date, end datenetworkdaysstart date,end datetable uppercell range lefttext findfindtext, within text righttextlentextfindfind text,within textAAcDEFGEmployee,tableToday Date:Full NametableLast NameGCaps,Hire date,Service Years,Salary.,In of Work DaystableFull NameAikmanGarytableLast NameAikmantableFirst NameGaryFishe,Bryan,tableAikmanFisheBryan,Felser,Cynthia,Felser,Cynthia,Parsley, Gwen,Parsley,Gwen,Leslic,jean,Leslic:,Jean,fImber, Cynthia,Imber,Cynthid,MGranger,Kevin,Granger,Kevin,Dunes, Annette,Dunes,Annette,Cusak, Barbara,Cusak,Barbara,fF
Enter the correct formula for cell that calculates the years of services the date in cell C and G to calculate the number of days the divide by to get the years. Use absolute addressing when referencing todays date.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
