on 10-17-2019 2:52 PM
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I like both answers! lol flipping coin for the winner...
GG Ayman! lol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Hope this formula will help you
=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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.