Put in in L4

=K4-1.

Format column L any date format.

Then in L5 put the formula
=L4-1

Copy the cell L5 down the column for 45 day until cell L48.

"da_bigone" wrote:

I am creating a worksheet to track a 45 day window. I need the worksheet to
count down in days from 45 to 1 in column L from any date entered in column K.

45 Day Count Down Timer In L4 When Date Is Entered in K4