Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I need help creating a formula in a sheet to countdown to a deadline. Essentially, we have a deadline for a specific date, and a few milestones that we need to see a countdown based on the final date.
If you want to only count working days:
=NETWORKDAYS(TODAY(), [End Date]1)
If you want to count all days:
=NETDAYS(TODAY(), [End Date]1)
