Firstworkdate function issue.

[#1]

Hi Everyone,

When we use firstworkdate() function it excludes Saturdays and Sundays, but I want to include Saturday as my working day, so what should i do? Is there any other function to calculate the same? Or any other method Please help?

Thanks in advance.

-CS

[jonathandienst]

There is no standard option to include Saturdays as working days. If you are using a master calendar, then it is easy enough to create a workday flag that is set for Monday - Saturday. Then you can create expressions using this flag - for example NetWorkDays(..) becomes a count/sum of the flag values.

[#3]

Thank You Jonathan for quick reply. This might help.

[prat1507]

Hi Chiranjeev

Maybe this

=date(FirstWorkDate(today(),v_n_days)

+Div(WEEKDAY(today()-v_n_days-6)+1-(today()-v_n_days)+today(),7))

where v_n_days is no. of days from firstworkdate which is today.

Regards
Pratyush

[#5]

Thank You Pratyush, It works.