Formula to track Number of Days within a project

Autumn Montegna

Good Afternoon,

I'm currently making a summary sheet for a summer project. In the summary sheet I want to include the number of days between the start date (located in the date column) and today's date (the date when information is viewed). This would number would change automatically as the days progress, almost like a count down. Is there any I can do that? I tried =NETWORKDAY(Date1,Today) but of course that didn't work. I'm still a novice. Thanks for the help!

Andrée Starå

Hi @Autumn Montegna

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Autumn Montegna

You would need to use the TODAY function, not just the word "Today". Try something like this:

=NETWORKDAY(Date@row, TODAY())

The blank parentheses () indicate that you're looking exactly for Today's date, not yesterdays which would be TODAY(-1) or tomorrow's which would be TODAY(1). See here for more information on the TODAY Function.

If this doesn't work, I agree with Andrée, it would be helpful to see screen captures but please block out any sensitive data.

Cheers!

Genevieve

Andrée Starå

@Genevieve P

Nice catch! 😉

Autumn Montegna

This worked great! Thank you so much for your help!

Genevieve P.

Haha, thanks @Andrée Starå.

@Autumn Montegna Glad to hear it works! 🙂