#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Formula: Remaining Work based on Any given Date

Options
edited 12/09/19

Does anyone have a formula that will calculate the following:

Reaming = 194

X = How many do i need to complete per day in order to make the deadline.

Note: X should change based on today's date

Thanks

Tags:

• ✭✭✭✭✭
Options

Kal-El,

Here is how I solved this one: the formula under Comp / Day is "=Remaining1 / (Deadline1 - TODAY())"

Let me know if you have any questions on this.

Steve

• Options

How do I only include working days (M-F)?

• Options

How do I only include working days (M-F)?

• Options

Remaining11 is 194

My formula: =Remaining11 / (Deadline1 - TODAY())

My result were 13,8571, which I know is not correct.

• Options

Disregard User Error. However, how do I exclude weekends and just calculate M-F?

• ✭✭✭✭✭
Options

Kal-El,

To answer your question in the simplest way, I have done the following (as shown in the screen shot below):

• Insert a column to calculate the work days between today and the deadline, using this formula: =NETWORKDAYS(TODAY(), Deadline1)
• Revise the Comp / Day formula as follows: =Remaining1 / [Work Days]1

Let me know if that doesn't work for you. Sorry for the delay in responding to you.

Steve

This discussion has been closed.