# Calculate X business day of the month

I need to calculate 7 business days before the end of the month.. how to count 7 days without including Sat/Sundays?

example.. October would be 10/23

thanks!

10|10000 characters needed characters exceeded

### Related questions

Posted on Oct 17, 2019 at 04:00 PM

or as follow:

CurDate: =CurrentDate()

lastDayOfMonth: =LastDayOfMonth([CurDate])

DayNrOfWeek: =DayNumberOfWeek([lastDayOfMonth])

DateX: =(7+[DayNrOfWeek]-2)

DDD: =RelativeDate([lastDayOfMonth];-[DateX]+1)

bdays.jpg (23.1 kB)
10|10000 characters needed characters exceeded
• Hi this formula will fail when the end date will come on Sunday or Saturday plz check.

Plz validate the logic for Saturday and Sunday.

Thanks.

• Posted on Oct 17, 2019 at 03:49 PM

Hi,

=If(DayNumberOfWeek(LastDayOfMonth(CurrentDate())) InList(1;7);RelativeDate(LastDayOfMonth(CurrentDate());-10);If(DayNumberOfWeek(LastDayOfMonth(CurrentDate()))=6;RelativeDate(LastDayOfMonth(CurrentDate());-9) ;RelativeDate(LastDayOfMonth(CurrentDate());-8)))

Thanks,

10|10000 characters needed characters exceeded
• Posted on Oct 17, 2019 at 05:04 PM
-1

I like both answers! lol flipping coin for the winner...

GG Ayman! lol