If 'x' then 'y' unless 'z' formula with dates - help please

[acana]

Hi,

I'm not a very experienced excel user and I'm struggling with getting the formula right on this one. You will see the columns I am dealing with below. Basically, I need column C to produce either a date or N/A.

• If the date in A is before 1st June 2022 then the date in C should be 31st August 2022 unless B is yes in which case C should be N/A
• If the date in A is on or after 1st June 2022 then the date in C should be A2+90days unless B is yes in which case C should be N/A

(In the UK so dates are DD/MM/YYYY)

Example below of what I would need column C to look like.

	A	B	C
1	Date File Opened	Is the file still in use?	Date file should be archived
2	02/04/2020	No	31/08/2022
3	04/06/2022	No	02/09/2022
4	05/08/2021	Yes	N/A
5	09/07/2022	Yes	N/A

Any help would be greatly appreciated.

Thanks

 

[etaf]

=IF(A2="","",IF( B2="yes", "N/A", IF(A2 < DATEVALUE("1/6/22"),DATEVALUE("31/8/22"), A2+90)))

xl2bb is not working for me on my new laptop - sorry
i will try again

Book1
	A	B	C
1	date	in use	archive
2	6/2/22		8/31/22
3	5/3/22		8/31/22
4	6/4/22		9/2/22
5	6/5/22	yes	N/A
6
7	1/1/21	yes	N/A
8
9
10
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2="","",IF( B2="yes", "N/A", IF(A2 < DATEVALUE("1/6/22"),DATEVALUE("31/8/22"), A2+90)))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(B2="yes","N/A",IF(A2<DATE(2022,6,1),DATE(2022,8,31),A2+90))