If today() = 3,Wednesday = add 3 days = Monday (exclude Saturday,Sunday = 2days). If today() = 4,Thursday = add 3 days = Tuesday (exclude Saturday,Sunday = 2 days). If today() = 5,Friday = add 3 days = Wednesday (exclude Saturday,Sunday = 2days). If today() = 6,Saturday = add 3 days = Wednesday (exclude Sunday = 1days).
Case else logic: If today() = monday = just add 3 days = Thursday ( no need to exclude Saturday,Sunday = 2days). If today() = Tuesday =just add 3 days = Friday (no need to exclude Saturday,Sunday = 2days).
Can you please Let me know if it helps or not!!!
If it helps don't forget to mark this as a best answer!!!
Hi Raj, Thanks for the reply, but if its wednesday(3, TODAY() + 2 + 3), we are adding Thursday and friday, leaving saturday n sunday we add 3 days, when its Thursday (4, TODAY() + 2 + 3,) why we need to add 2 days we have to add only 1 + 3 and again it its friday ( 5, TODAY() + 2 + 3,), we have to add just 3 then, can u explain on this more?
If today() = 3,Wednesday = add 3 days = Monday (exclude Saturday,Sunday = 2days). If today() = 4,Thursday = add 3 days = Tuesday (exclude Saturday,Sunday = 2 days). If today() = 5,Friday = add 3 days = Wednesday (exclude Saturday,Sunday = 2days). If today() = 6,Saturday = add 3 days = Wednesday (exclude Sunday = 1days).
Case else logic: If today() = monday = just add 3 days = Thursday ( no need to exclude Saturday,Sunday = 2days). If today() = Tuesday =just add 3 days = Friday (no need to exclude Saturday,Sunday = 2days).
Can you please Let me know if it helps or not!!!
If it helps don't forget to mark this as a best answer!!!
If today() = 3,Wednesday = add 3 days = Monday (exclude Saturday,Sunday = 2days).
If today() = 4,Thursday = add 3 days = Tuesday (exclude Saturday,Sunday = 2 days).
If today() = 5,Friday = add 3 days = Wednesday (exclude Saturday,Sunday = 2days).
If today() = 6,Saturday = add 3 days = Wednesday (exclude Sunday = 1days).
Case else logic:
If today() = monday = just add 3 days = Thursday ( no need to exclude Saturday,Sunday = 2days).
If today() = Tuesday =just add 3 days = Friday (no need to exclude Saturday,Sunday = 2days).
Can you please Let me know if it helps or not!!!
If it helps don't forget to mark this as a best answer!!!
Thanks,
Raj
All Answers
The formula exclude the weekends and add the three days:
If the Today is wednesday then it will add the 3 days that is thursday,Friday then display the date as Monday which ecxlude the Satuday and Sunday.
CASE( MOD( date - DATE( 1900, 1, 7 ), 7 ), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", "Saturday" )
Can you please Let me know if it works or not!!!
If it helps don't forget to mark this as a best answer!!!
Thanks,
Raj
If today() = 3,Wednesday = add 3 days = Monday (exclude Saturday,Sunday = 2days).
If today() = 4,Thursday = add 3 days = Tuesday (exclude Saturday,Sunday = 2 days).
If today() = 5,Friday = add 3 days = Wednesday (exclude Saturday,Sunday = 2days).
If today() = 6,Saturday = add 3 days = Wednesday (exclude Sunday = 1days).
Case else logic:
If today() = monday = just add 3 days = Thursday ( no need to exclude Saturday,Sunday = 2days).
If today() = Tuesday =just add 3 days = Friday (no need to exclude Saturday,Sunday = 2days).
Can you please Let me know if it helps or not!!!
If it helps don't forget to mark this as a best answer!!!
Thanks,
Raj