+ Start a Discussion
Shantanu Punekar 5Shantanu 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.
Best Answer chosen by Shantanu Punekar 5
veda Hebbarveda Hebbar
Hi Shantanu Punekar 5,

please try below formula to add 10 business days.from today
 
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

All Answers

veda Hebbarveda Hebbar
Hi Shantanu Punekar 5,

please try below formula to add 10 business days.from today
 
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 5Shantanu Punekar 5
Thanks a lot vedashri.
How about 5 days?
veda Hebbarveda 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

)