automatically reseting countdown

[toadfrog]

I’m trying to create an excel spared sheet that counts down to a specific date (example 1/15/2010) and upon reaching that date reset automatically to the same date then next year (1/15/2011) and start the count down all over again.

I’m pulling my hair out on this one.

 

[jbeaucaire]

Put the reset date for the first year in a cell, let's say A1 = 1/1/2000

Now, instead of counting down with TODAY() directly used in the formula, use the date in A1 to calculate the same date in NEXT year...

=IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))>TODAY(),
DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY(),
DATE(YEAR(TODAY())+1,MONTH(A1),DAY(A1))-TODAY())