How to subtract dates from each other?

[mrichelieu (madeline)]

I have Stage, Creation date, and Current date columns. I am trying to figure out the amount of time has elapsed before an item moves to a new stage. For example: if the Creation date was Feb 10, 2024 and the Current date is Feb 13, 2024 and I move the stage, I want that column to show 3 days to indicate the item spent 3 days in this stage.

I have tried the following formulas but nothing populates.

• SUBTRACT({Creation Date}, TODAY())
• DATEDIFF(TODAY(), {Creation date}, “days”)

[kaylak]

Hi @mrichelieu,

You can create this using this formula:
ROUND(DAYS(TODAY(),{Creation Date}),0)

This would allow you to remove the “current date” column to clean up the board unless there is another reason for having that column.

Here’s what this looks like on my test board

Hope this helps!