Difference in Days - Date Calculation

[limfungkeat]

Hi Gurus out there ,

i am calculating the Aging (No of days) , where the calculation is - Entered Date - Approved Date (See atatched Excel Sheet). However , the calculation is bit out especially when it comes to, when the Entered Date and Approved Date is the same . 

Entered Date  :  timestamp(ENTERED_DATE,'DD-MMM-YY')

Approved Date   : timestamp(ORDER_APPROVED_DATE,'DD-MMM-YY')

Aging : round(ENTERED_DATE-ORDER_APPROVED_DATE)

p/s Column E is finding / expecatation from user

How am i suppose to get the exact Aging (no. of days ) ? 

[marcus_sommer · Accepted solution]

You may try it with: floor(ENTERED_DATE) - floor(ORDER_APPROVED_DATE)

- Marcus

[limfungkeat]

Thanks Marcus ..is just that easy ? Ha ha ha ...