You need to sign in to do that
Don't have an account?
Shantanu Punekar 5
Formula to exclude weekends.
Hello,
I found below formula to add 3 business days to current date, this excludes the weends.
CASE(MOD(TODAY()- DATE(1900, 1, 7), 7), 0, TODAY()+3, 1, TODAY()+3, 2, TODAY()+3,3, TODAY()+5, 4, TODAY()+5, 5, TODAY()+5, 6, TODAY()+4,null)
I need to modify this formula to add 10 / 15 + todays date, i'm unable to identify where exactly to change in the formula which will display TODAY() + 10 business days.
Please help,
Thanks in advance.
I found below formula to add 3 business days to current date, this excludes the weends.
CASE(MOD(TODAY()- DATE(1900, 1, 7), 7), 0, TODAY()+3, 1, TODAY()+3, 2, TODAY()+3,3, TODAY()+5, 4, TODAY()+5, 5, TODAY()+5, 6, TODAY()+4,null)
I need to modify this formula to add 10 / 15 + todays date, i'm unable to identify where exactly to change in the formula which will display TODAY() + 10 business days.
Please help,
Thanks in advance.
please try below formula to add 10 business days.from today
Thanks,
vedashri
All Answers
please try below formula to add 10 business days.from today
Thanks,
vedashri
How about 5 days?
please try below formula for 5days