How do I get an automatic count down to the number of days, minutes etc to an event
J junedb May 3, 2009 #1 How do I get an automatic count down to the number of days, minutes etc to an event
J JLatham May 3, 2009 #2 A web search for 'Excel countdown timer' returns several hits for a bunch of solutions. Here is a link to one that I believe Bob Philips wrote: http://www.xldynamic.com/source/xld.XtraTime.html and here is an add-in from Tushar Mehta that should be a solid tool http://www.tushar-mehta.com/excel/software/clocks/countdown.html Hope these help.
A web search for 'Excel countdown timer' returns several hits for a bunch of solutions. Here is a link to one that I believe Bob Philips wrote: http://www.xldynamic.com/source/xld.XtraTime.html and here is an add-in from Tushar Mehta that should be a solid tool http://www.tushar-mehta.com/excel/software/clocks/countdown.html Hope these help.
J Jacob Skaria May 3, 2009 #3 To get the number of days from now to a future date you can use the DATEDIF function Suppose A1 = 5/15/2009 =DATEDIF(TODAY(),A1,"d") will give you the number of days more... If this post helps click Yes
To get the number of days from now to a future date you can use the DATEDIF function Suppose A1 = 5/15/2009 =DATEDIF(TODAY(),A1,"d") will give you the number of days more... If this post helps click Yes
