ShowAll Questionssorted byDate Posted
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.

Best Answer chosen by Shantanu Punekar 5
veda Hebbar
Hi Shantanu Punekar 5,

CASE(

MOD( TODAY() - DATE(1900, 1, 7), 7),

0, TODAY()+12,
1, TODAY()+14,
2, TODAY()+14,
3, TODAY()+14,
4, TODAY()+14,
5, TODAY()+14,
6, TODAY()+13,
null

)

Thanks,
vedashri

veda Hebbar
Hi Shantanu Punekar 5,

CASE(

MOD( TODAY() - DATE(1900, 1, 7), 7),

0, TODAY()+12,
1, TODAY()+14,
2, TODAY()+14,
3, TODAY()+14,
4, TODAY()+14,
5, TODAY()+14,
6, TODAY()+13,
null

)

Thanks,
vedashri
This was selected as the best answer
Shantanu Punekar 5
Thanks a lot vedashri.
veda Hebbar
Most Welcome..:)

please try below formula for 5days
CASE(

MOD( TODAY() - DATE(1900, 1, 7), 7),

0, TODAY()+5,
1, TODAY()+7,
2, TODAY()+7,
3, TODAY()+7,
4, TODAY()+7,
5, TODAY()+7,
6, TODAY()+6,
null

)