Countdown from today not working

08/27/18 Edited 12/09/19

I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't really helpful for me. I have turned on and off the duration function, it gave me a countdown of the full range, but that isn't what I need. See screen shot

Doc2.jpg

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try...

     

    =NETWORKDAYS(TODAY(), [End Date]@row)

     

     

    thinkspi.com

  • Mike WildayMike Wilday ✭✭✭✭✭

    To explain Paul's formula: 

    • Today()

      Doesn't need any date put inside it. Every time you open the sheet the Today() formula will populate with the current date. You can also adjust the date by putting a -3 inside the parenthesis. =Today(-3) will give return the date of today minus 3 days.
    • [End Date]

      The column you are referencing.
    • @row

      Indicates that you want the row number that the formula is on. This prevents you from messing up and typing in a wrong row number. @row will always process you formula for the row it exists on or is pointing at in the case of a range.

    All-together these prevent you from having to input actualy dates as you have in your example. You were referencing actual data rather than the data in the columns that already existed. 

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Thanks Mike. I wanted to go into more detail with it, but was crazy short on time. I figured I could throw a solution out there then explain this morning, but it looks like you beat me to it. yes

    thinkspi.com

  • Mike WildayMike Wilday ✭✭✭✭✭

    yes No problemo. Sorry to steal your thunder! 

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Haha. No worries in the least. The purpose of the community is to help each other out. It doesn't matter where the info comes from as long as it helps, so no thunder stolen at all.

    thinkspi.com

Sign In or Register to comment.