I need a formula for counting days until Due date

RGarrels

I feel like this is a simple formula that I am over thinking.

I have a sheet with one due date column. I want a formula to go in a second column that tells me how many days from "TODAY" is the due date.

Carson Penticuff

Give this a try:

=IF(ISDATE([Due Date]@row), NETDAYS(TODAY(), [Due Date]@row), "")

Paul Newcome

I would suggest this:

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

Carson Penticuff

NETDAYS will give you the number of days until the due date. NETWORKDAYS will give you how many working days until the due date. It all comes down to your implementation and what you would like the result to be.

Carson Penticuff

Give this a try:

=IF(ISDATE([Due Date]@row), NETDAYS(TODAY(), [Due Date]@row), "")

Paul Newcome

I would suggest this:

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

RGarrels

Thank you both. I used: =NETDAYS(TODAY(), [Due Date]@row) and it's working so far. Did I miss something?

Carson Penticuff

NETDAYS will give you the number of days until the due date. NETWORKDAYS will give you how many working days until the due date. It all comes down to your implementation and what you would like the result to be.