excel if statement + date

[kelvin_9]

Hi All,

i'm trying to use one formula in my workbook with below criteria but i get some difficulties in this, anyone can help me out would be appreciated
assuming cell A1 is today, and i want C1 return date+1 / date+2 / date+3 if date in A1 is monday / tuesday / friday respectively.
last but not least, i will use this formula in VBA likely: Selection.AutoFill Destination:=Range("C1:C" & Range("A" & Rows.Count).End(xlUp).Row) finally.
my answer in this example in C1 should be 22 march, 2022

Book1
	A	B	C
1	21 March, 2022
Sheet1

Cell Formulas
Range	Formula
A1	A1	=TODAY()
C1	C1	=IF(A1="Monday","a1+1",IF(A1="Tuesday","a1+2",IF(A1="Friday","a1+3","")))

thank you very much

 

[Fluff]

How about

=CHOOSE(WEEKDAY(A1,2),A1+1,A1+2,"","",A1+3,"","")

 

[kelvin_9]

How about

=CHOOSE(WEEKDAY(A1,2),A1+1,A1+2,"","",A1+3,"","")

Fluff
thank you very much for your great help and quick response
exactly what i want

i'm not very get this combination
just curious, what if i need one or two more criteria say: IF(A1="wednesday","a1+4", IF(A1="saturday","a1+5"
what should i change

thanks again

 

[Fluff]

How about

=CHOOSE(WEEKDAY(A1,2),A1+1,A1+2,A1+4,"",A1+3,A1+5,"")

 

[kelvin_9]

How about

=CHOOSE(WEEKDAY(A1,2),A1+1,A1+2,A1+4,"",A1+3,A1+5,"")

Fluff
thank you very much

really amazing and i hope i could understand this combination as soon as i can

 

[Fluff]

You're welcome & thanks for the feedback.