I have been trying to figure out a formula to count days from a date column, Any help?

Shaun.white81

Example:

Column A—————-Column B

Date sent out———#of days out

06/20/25———————3

05/31/25———————23

05/23/25——————-30

Darla Brown

Hi,

Do you have a second date column? If not, you could make Column B a date column that has the formula

=[Column A]@row+3

=[Column B]@row+23

and etc

Otherwise, you would need a second date column and the formula would be a sum between the 2.

Does that help?

Paul Newcome

@Shaun.white81 Is what @Darla Brown suggested what you needed? The way I read it is that you need a number of days something has been open/out based on a start date in comparison to today's date.

If that is correct, then you would be able to use something along the lines of

=TODAY() - [Date Sent Out]@row

If I have read it wrong, please excuse my clutter.

Darla Brown

Hi,

Do you have a second date column? If not, you could make Column B a date column that has the formula

=[Column A]@row+3

=[Column B]@row+23

and etc

Otherwise, you would need a second date column and the formula would be a sum between the 2.

Does that help?

Paul Newcome

@Shaun.white81 Is what @Darla Brown suggested what you needed? The way I read it is that you need a number of days something has been open/out based on a start date in comparison to today's date.

If that is correct, then you would be able to use something along the lines of

=TODAY() - [Date Sent Out]@row

If I have read it wrong, please excuse my clutter.

Shaun.white81

https://community.smartsheet.com/discussion/comment/487790#Comment_487790

@Paul Newcome, @Darla Brown's worked. But yours gets exactly what I wanted. Thank you to you both and i look forward to getting more answers as I learn Smartsheet from the beginning.

All the Best,

Shaun

Paul Newcome

Happy to help. 👍️