FirstWorkDate

[Anonymous]

Hi all,

I need an advice, can we use FirstWorkDate() for Monday to Saturday work schedule?

If yes, then how?

Thanks in advance.

Yashada

[senpradip007]

Its Monday to Friday.

[Anonymous]

Yes, but is there any way we can use that function for monday to saturday?

[Gysbert_Wassenaar · Accepted solution]

No, the firstworkdate function treats saturdays as nonworking days. If you want a monday to saturday schedule simply check for sundays and remove those from the total number of days.

[#5]

I am tearing my hair out over this.

My developers enter their plan for the next working day before going each day. (i.e. on Friday, July 4, they enter the data for Monday, July 7). The manager wants to see the report for the next working day each night around 7 pm.

I entered in the Search area of the PlanDay listbox the following:

=FirstWorkDate(today(1)+1,1). (I've tried with today(0) as well; same result)

I also have a text box on the page showing ='Today is '&today(1)

The text box shows "July 4, 2014", but when I enter the FirstWorkDate formula in the PlanDay listbox, it selects

July 4, not July 7.

How do I use this function to get the next working day?

thanks,

[Gysbert_Wassenaar]

Use the LastWorkDate function instead: LastWorkDate(today(1)+1,1)