Hi, I have combined 3 different cells to get 1 single date using Date(A1,B1,C1) format. That is the joining date of staff. Now I need to calculate length of service as of a particular date. I am using the ROUND(YEARFRAC(AN10,$AS$4,3),2) format where AN10 is the formatted joining date and AS4 contains the date for which I want to calculate the length of service. But I am not getting the right answer. The cell returns the value 110.20 whereas it is supposed to be 10.13. Can anyone help? TIA
