What is the formula to subtract today's date from due date column so I can see remaining days

ccortes

Sandra Guzman

Hi @ccortes,

Try this formula. Make sure that the column header is documented as it is in your sheet and replace "Due Date" in the formula below as appropriate. You will want to also convert this to a column formula if you have multiple rows that you want this to apply to.

=TODAY() - [Due Date]@row

All the best,

Sandra

Sandra Guzman

Hi @ccortes,

Glad the formula worked for you! Please make sure to mark the response as yes to answering your question. 😊

As for converting to a column formula, all you need to do is right click in the cell that you added the formula to. You should see the menu of options available to you. Scroll down and click on the "Convert to Column Formula." Once you do that you should notice the formula symbol added to the column header.

Menu of options to convert to column formula.

Formula added to column displays fx in the column header.

All the best,

Sandra

ccortes

Do you guys know how the formula to subtract today's date from the Due Date column so it will display the remaining days in the Remaining Days column?

I do not have a today's date column as I am thinking this is auto generated since it is a smartsheet. Any advice?

Sandra Guzman

Hi @ccortes,

Try this formula. Make sure that the column header is documented as it is in your sheet and replace "Due Date" in the formula below as appropriate. You will want to also convert this to a column formula if you have multiple rows that you want this to apply to.

=TODAY() - [Due Date]@row

All the best,

Sandra

ccortes

This worked perfectly!!!! I noticed you said I should convert this to a column formula if I have multiple rows, how do I do that so each row will have this formula?

Thank you Sandra!

Sandra Guzman

Hi @ccortes,

Glad the formula worked for you! Please make sure to mark the response as yes to answering your question. 😊

As for converting to a column formula, all you need to do is right click in the cell that you added the formula to. You should see the menu of options available to you. Scroll down and click on the "Convert to Column Formula." Once you do that you should notice the formula symbol added to the column header.

Menu of options to convert to column formula.

Formula added to column displays fx in the column header.

All the best,

Sandra