Working days

[#1]

How to calculate workingdays between startdate and enddate? And if enddate is null,it should consider todays date.

[tresesco]

Try networkdays().

[maleksafa]

networkdays (start:date, end_date {, holiday})

[#4]

Hi Ramya

Try this

Floor(Interval(StartDate-EndDate,'DD')) -> For Days

Hope it helps

[#5 · Accepted solution]

Hi Ramya,

as a few others have said, have a look at networkdays(), you can do a check for nulls within that and use today instead

networkdays([startdate], If(isnull([enddate]),today(),[enddate]))

hope that helps

Joe

[MarcoWedel]

=NetWorkDays(startdate, Alt(enddate, Today()))

[#7]

you will have to play about a bit, interval is good, but you may have to convert to date & time as required ...

[MK_QSL]

=NetWorkDays(StartDate, IF(IsNull(EndDate) or Len(Trim(EndDate))=0,Today(),EndDate))

[Anonymous]

What to be done if the Week offs are different from Saturdays  and Sundays??????????????