Ageing report in excel

[sam9989]

Hi all,

Please help me out to create an ageing report.I do have an excel sheet in which one of the column talks about order date.This is in the format of "Mon-date YEAR HH:MM".For ex: Apr-11 2018 23:45

Could you help me to create a a formula which will do this today's date and current time - order date?And that should be in days.

Many thanks.

[Mvaldesi]

Does this work for you?

“=NOW() – [Order Date]” calculates the current date/time minus your order date and will recalculate pretty much whenever you perform an action within the workbook.
“=TODAY90 – [Order Date]” calculates just the current date minus your order day and only recalculates the next day.

[sam9989]

Thanks a lot.