Extract Day

[#1]

Hi,

I have to extract 5 day from formula Networkdays(Monthstart(Today()),Monthend(Today())).

Regards,

Piyush jain

[Clever_Anjos]

Maybe I´m missing something, but

Networkdays(Monthstart(Today()),Monthend(Today())) - 5 don´t do what you want?

[#3]

Hi Clever,

I just want date of 5th day extracted from above formula.

Regards

Piyush Jain

[Clever_Anjos]

Well, Networkdays calculate how many workdays you have between 2 dates.

If you want 5th workday after a day, you should use

=LastWorkDate(Today(),5)

[#5]

Hi,

But it will give without excluding saturday sunaday and holiday.

regards,

Piyush jain

[Jason_Michaelides]

Today() + Networkdays(Monthstart(Today()),Monthend(Today()))

That work?

[tresB]

Lastworkdate() excludes Sat/Sun days, if you have holiday list you can include those as well as third parameter: