Add Days to Wednesdays and Saturdays

[Alan L 185]

Hi

I am trying to create a formula that adds three days if a date is a Wednesday and four days if it is a Saturday.

Examples:
Input 3/7/2019
Output 6/7/2019
Because the 3/07/2019 is a Wednesday the formula will add 3 days and the answer would be the 6/7/2019

Input 6/7/2019
Output 10/7/2019
Because the 6/07/2019 is a Saturday the formula will add 4 days and the answer would be the 10/7/2019

Could someone please help me?

[FDibbins]

Try this...
IF(WEEKDAY(N7,2)=3,3,IF(WEEKDAY(N7,2)=6,4))

[Alan L 185]

Hi Ford

Thanks for your response.

I've had a go but can't get the formula to work correctly.

I've attached a simple example so that you can see what the problem is.

Regards,

Alan

[shg]

	A	B	C
1	Mon 01 Jul 2019	Mon 01 Jul 2019	B1: =A1 + IF(WEEKDAY(A1) = 4, 3, IF(WEEKDAY(A1) = 7, 4))
2	Tue 02 Jul 2019	Tue 02 Jul 2019
3	Wed 03 Jul 2019	Sat 06 Jul 2019
4	Thu 04 Jul 2019	Thu 04 Jul 2019
5	Fri 05 Jul 2019	Fri 05 Jul 2019
6	Sat 06 Jul 2019	Wed 10 Jul 2019
7	Sun 07 Jul 2019	Sun 07 Jul 2019

[Alan L 185]

Hi shg

Thanks very much that worked well .

All the best,

AlanL