Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I count the number of days between two dates?
I have ClaimDate and ConcludedDate and I want to count the number of days in between.
Hi,
U can use like (ConcludeDate - ClaimDate)
thanks
try this
NetWorkDays(ClaimDate ,ConcludedDate )
I tried to put this in a KPI, but it did not work. Does anyone have another idea?
If you want to calculate all days in between dates, then you can use
ConcludedDate - ClaimDate
If you want to calculate only working days (Monday-Friday), then use
Networkdays (ClaimDate , ConcludedDate )
Floor(ConcludedDate) - Floor(ClaimDate)
Hi
Try it.
=Floor(Interval(ConcludedDate-ClaimDate,'DD'))
Regards.