This may be a super simple answer...... but I...

This may be a super simple answerโ€ฆ but Iโ€™ve been spinning my wheels. All i want to do is show the number of since todayโ€ฆ for example: Number of days outstanding for Invoice. I thought I could do something like and equation like Today()-[invoicedate] but the duration result looks like 024:00:00โ€ฆ I would prefer it to look like 1 day outstanding. How would I do this?

0 2 329
2 REPLIES 2

Hi try something like this =HOUR(TODAY() - [Datecol]) / 24

That works perfectly. Thank you

Top Labels in this Space