need to show date countdown
 

have a column showing date of action next column shows next action date as 12
months date. next column needs to show days couning down from 365 to 0

=B1-A1

?

--
HTH

-------

Bob Phillips
"petergw" wrote in message
...
have a column showing date of action next column shows next action date as
12
months date. next column needs to show days couning down from 365 to 0