Try

=C2-C1

Format as general.

Mike

"Narnimar" wrote:

1. What is the formula for calculating the elapsed number of days to return
in c1 for any selected value which is in a cell a1 and a given date in b1.
2. What is the formula for calculating the elapsed number of days to return
in c2 for any selected value which is in a cell a2 where the day to be
continued from the c1.