Answer:
The formula is given below
(C20-E4)/365
where 365 is the no of the days.
The method indicated by the content of your question would be:
=($C$20-E4)/365
Format E4 as 'Number' - no decimal
Thanks
7.5m questions
10.1m answers