# Days Remaining from a Date

Options

Hello!

I'm trying to calculate how many days until the Start Date. I used the following formula: =[Start Date]6 - TODAY()

What am I missing? The date column is a date type and the formula column is text/number.

Thanks!

Options

Yes thank you!!!

• ✭✭✭✭✭✭
Options

Hi Tess,

It should work.

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Thank you!

• ✭✭✭✭✭✭
Options

Strange!

I'd be happy too take a quick look!

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Thank you so much!

Ultimately what I'm trying to do is SUM the Slot Total for everything with a start date in the next 30 days, SUM the slot total for rows with start dates between 30 and 60, and then SUM the slot total for start dates between 60 and 90. So I was originally going to use that formula to change the dates to days and then try to figure out an IF formula to SUM the slot totals for any rows with start dates in the above time ranges. Does that make sense? Thanks!

• ✭✭✭✭✭✭
Options

Are you getting an error or just an incorrect number?

• Options

I'm getting #invalid operation

• ✭✭✭✭✭✭
Options

Is it a cell link or a formula populating the date?

• ✭✭✭✭✭✭
Options

Double-check that the Start Date column is a date type column.

Was that the error?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.