I want to use if statement

[Firelyy]

Hi,

I would like to create a if statement that states If cell g4 states yes then add 3 months to the date in E4.

Thanks so much

 

[Alex Blakenburg]

Something like this ?

=IF(G4="Yes",EDATE(E4,3),"")

 

[etaf]

=IF( G4="yes", DATE(YEAR(E4),MONTH(E4)+3,DAY(E4)),"")

Book2
	A	B	C	D	E	F	G	H
1
2
3
4					3/30/24		yes	6/30/24
Sheet1

Cell Formulas
Range	Formula
H4	H4	=IF( G4="yes", DATE(YEAR(E4),MONTH(E4)+3,DAY(E4)),"")

 

[Peter_SSs]

Welcome to the MrExcel board!

Could this be what you mean?
Col H does not use IF so I have included col I even though that formula is a bit longer.

24 03 30.xlsm
	E	F	G	H	I
1
2
3
4	15/02/2024		Yes	15/05/2024	15/05/2024
5	15/02/2024		No	15/02/2024	15/02/2024
Firelyy

Cell Formulas
Range	Formula
H4:H5	H4	=EDATE(E4,3*(G4="Yes"))
I4:I5	I4	=EDATE(E4,IF(G4="Yes",3,0))

 

[Firelyy]

Welcome to the MrExcel board!

Could this be what you mean?
Col H does not use IF so I have included col I even though that formula is a bit longer.

24 03 30.xlsm
	E	F	G	H	I
1
2
3
4	15/02/2024		Yes	15/05/2024	15/05/2024
5	15/02/2024		No	15/02/2024	15/02/2024
Firelyy

Cell Formulas
Range	Formula
H4:H5	H4	=EDATE(E4,3*(G4="Yes"))
I4:I5	I4	=EDATE(E4,IF(G4="Yes",3,0))

Thats exactly what I need but how do I then say if it says no to leave it blank? or say not needed

 

[MARK858]

Thats exactly what I need but how do I then say if it says no to leave it blank? or say not needed

Did you see post number 2?