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?
Hi try something like this =HOUR(TODAY() - [Datecol]) / 24
That works perfectly. Thank you
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |