Countdown Timer

[s_whitie]

Hi

Can any one help with this.

I currently have the following code to countdown to my holiday....

=DATEDIF(TODAY(),$C$2,"M") &" months " &DATEDIF(TODAY(),$C$2,"md") &" days "&TEXT($IN$11,1) &" until "&B2&"!!!!!"

This works absolutly fine but I have to keep updating the spreadsheet (f9) to show the current time outstanding.

Is there a way of getting the spreadsheet to show the countdown in "real time"?

Thanks