Can't figure out simple Formula - IF statement within 7 Days

[FanofExcel18]

Last Date: 5/30/2018
My formula: =IF(W3<=TODAY()-7,"N","Y")

W3=5/30/2018

I just want the formula to tell me has there been an update within the past week. However, its telling me only one answer for all results. So 6/11/2018 is telling me N when I want it to say Y, 5/30/2018 is telling me Y and it should say N.

Appreciate any help!

 

[jproffer]

I'm getting the exact opposite with (essentially) the same formula you're using...

Excel 2013/2016
	A	B
1	5/25/2018	N
2	5/26/2018	N
3	5/27/2018	N
4	5/28/2018	N
5	5/29/2018	N
6	5/30/2018	N
7	5/31/2018	N
8	6/1/2018	N
9	6/2/2018	N
10	6/3/2018	N
11	6/4/2018	N
12	6/5/2018	N
13	6/6/2018	N
14	6/7/2018	N
15	6/8/2018	N
16	6/9/2018	Y
17	6/10/2018	Y
18	6/11/2018	Y
19	6/12/2018	Y
20	6/13/2018	Y
21	6/14/2018	Y
22	6/15/2018	Y
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A1<=TODAY()-7,"N","Y")

Not sure why you would be getting the opposite answers. How is W3 populated? Hard typed date, or with a formula? (not that it should matter)

 

[jtakw]

Last Date: 5/30/2018
My formula: =IF(W3<=TODAY()-7,"N","Y")

W3=5/30/2018

I just want the formula to tell me has there been an update within the past week. However, its telling me only one answer for all results. So 6/11/2018 is telling me N when I want it to say Y, 5/30/2018 is telling me Y and it should say N.

Appreciate any help!

Hi,

At first you say the formula Always gives you the Same answer, then you say the answer is reversed between Y and N, which is it?

My guess is it's Always giving you Y as the answer, because I suspect the dates in W3 is Not a Real Date (Number), but Text.

See my sample below, Dates in Column A are All entered as TEXT, B1:B2 is using your formula and shows incorrect results, B4:B5 is my suggested "fix" and shows correct results.

Book1
	A	B
1	6/11/2018	Y
2	5/30/2018	Y
3
4	6/11/2018	Y
5	5/30/2018	N
Sheet87

Cell Formulas
Range	Formula
B1	=IF(A1<=TODAY()-7,"N","Y")
B4	=IF(A4+0<=TODAY()-7,"N","Y")