Remaining days automatically added to children rows

Alexander Sullivan

Hi,

I have been using this formula : =[Production Due Date]1 - TODAY() in a cell for my remaining days left for a due date.

it works great as long as i drag this formula in to added rows or added children rows.

What's the trick on getting this to work automatically in the entire cell no matter if new parent or children rows are added.

Alexander Sullivan

@Heather D thanks much :-)

Works great.

Heather Duff

Hi @Alexander Sullivan ,

Try this:

=[Production Due Date]@row - TODAY()

Then right click on that cell and click Convert to Column Formula. That will make the formula automatically appear in that column on every row.

Hope this helps!

Best,

Heather

Alexander Sullivan

@Heather D thanks much :-)

Works great.

Alexander Sullivan

@Heather D is there a way to go even further and have this formula take out(or not count ) the non working Saturdays and Sundays?

Heather Duff

@Alexander Sullivan ,

Great question! For that, you would probably want to use NETWORKDAYS:

=NETWORKDAYS([Production Due Date]@row, TODAY())

This function counts the number of weekdays (Mon-Fri) between the two values listed in parenthesis - in this case, your Production Due Date and today.

Alexander Sullivan

@Heather D that seems to work as well :-) now why is it showing me a negative Value?

total beginner in the works here .