How to update a 'Days old' column in sharepoint?

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I'm building a helpdesk sharepoint list and I need a column that shows the number of days old each item is.

I'm checked it up and found that I'll need to do a scheduled flow that increments the number of day(s) daily.

How would I achieve this?

Thanks for your help!

Regards,

Daniel

All responses (7)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: How to update a 'Days old' column in sharepoint?

Hi @Mira_Ghaly ,

Sorry for that! I'll check more carefully next time. I'm testing it now and will come back to you with feedback.

Thanks again for your help!
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to update a 'Days old' column in sharepoint?

@Anonymous there is missing) after [created]
Community Power Pla... on at

Like (0)

Report

Re: How to update a 'Days old' column in sharepoint?

Hi @Mira_Ghaly ,

I tried the formula you suggested and I got this error message:

Thank you!
Community Power Pla... on at

Like (0)

Report

Re: How to update a 'Days old' column in sharepoint?

Hi @Mira_Ghaly ,

Absolutely! Will do and will let you know.

Thanks again as always!

Regards,

Daniel
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to update a 'Days old' column in sharepoint?

@Anonymous

Yes please try it and make sure it is working as expected.
Community Power Pla... on at

Like (0)

Report

Re: How to update a 'Days old' column in sharepoint?

Hi @Mira_Ghaly ,

Thank you so much for this! Will this update daily to reflect the current number of days old the item is?

Thank you again for your help!

Regards,

Daniel
Verified answer

Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (2)

Report

Re: How to update a 'Days old' column in sharepoint?

@Anonymous

Have you tried using calculated column directly on sharepoint?

Round((Today()-[Created]),1)