How to count ageing? Date differences.

[#1]

Hi,

How to get ageing, say for example, due date is 8/1/2012 and today is 8/13/2012, expected ageing should be 12 days or 13 days, not sure with it.. how to get differences.... say TODAY minus DUE DATE?

need help, thanks.

[Sokkorn · Accepted solution]

Hi,

It simple to get this job done. Just use EndDate - StartDate. Ex. =Today() - DATE('01-08-2012') ==> Returen 12.

Or use Networkdays(start:date, end_date {, holiday})  ==> Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Regards,

Sokkorn

[#3]

You can also try using AGE to get the required result!

[#4]

thanks.

[kalyandg]

hi

          i used EndDate-StartDate, we get answer as substraction, (eg)  StartDate=08/01/2012 and EndDate=08/15/2012,  if we calculate as per your answer it substracts 15-1=14, but it is not right, it should be 15 days. Please help me to solve this problem