Count Down Formula

Stephanie Taylor

Does anyone know a formula that can count down days (for example how many days to an election)? 

Tim Meeks

Steph,

 

I think this will work.

 

=[Election Date]2 - TODAY()

 

Enter your election date and have another column for the Days remaining.

 

let me know.

 

Tim

Stephanie Taylor

I think that might work.  I'll let you know tomorrow. 

 

Thanks Tim!

Stephanie Taylor

Tim, 

 

The formula above works great.  Thanks!!

Jake Friedberg

Hi, 

Is there a way to do a countdown of today from the final completation date of your project? I've tried playing around with this formula but I can't seem to get it working.

Jake Friedberg

Nevermind! I got it! But, how can I delete the calendar format for one of the cells in a collumn?

RoxanneF

Stumbled on this thread - Tim is there a specific format for adding in the event date? I just input it into where you had written 'Election Date' but got an error stating "#UNPARSEABLE" below is the formula i input. I basically want it to count down how many weeks to go from the event date using the start date of each task (certain tasks due 8 weeks out, 6 weeks out etc etc) and I have already build my task sheet with start and end dates.

=[04/25/18]2 - TODAY([Start Date]4)

Is there something I can add to the end of the formula that when I drag the formula down to other cells, it will know to go to the next start date inline with that cell - ie Start Date5, Start Date6 etc etc. AND - if I can go even further - I want it to calculate in weeks rather than days?