Macro to count down days

[Savuti]

Hello all, I have 5 days to place an order from the date entered into any cell in "H" column (60 rows) but need the days to count down in the adjacent cell in column "T"

I have tried different ways but cannot crack this - any help much appreciated.

 

[CWatts]

Try:

=H1+5-TODAY()

 

[AlphaFrog]

Excel Workbook
	H	T
1	3/12/2011	5
2	3/11/2011	4
3	3/10/2011	3
4	3/9/2011	2
5	3/8/2011	1
6	3/7/2011	0
7	3/6/2011	0
Sheet

 

[Savuti]

Both work great - thank you.