Need help with "IF" formula for dates older than 7 days

[kiwicanadian]

Hi,

I am making a spreadsheet where I want to note if 2 dates are greater than 7 days. For example:

[TABLE="width: 346"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Received[/TD]
[TD]Type[/TD]
[TD]collected[/TD]
[/TR]
[TR]
[TD]2/20/19[/TD]
[TD]swab[/TD]
[TD]15/02/2019[/TD]
[/TR]
[TR]
[TD]21/02/2019[/TD]
[TD]swab[/TD]
[TD]12/02/2019[/TD]
[/TR]
</tbody>[/TABLE]

I have been using: =IF((A1-C1)>=7, "Old"), and a few other similar but it is not working and it is putting everything as Old.

Any help would be greatly appreciated. Thanks!

 

[Michael M]

Try

Excel 2007
	A	B	C	D
1	Received	Type	collected
2	7/02/2019	swab	15/02/2019	old
3	6/02/2019	swab	12/02/2019	new
Sheet1

Cell Formulas
Range	Formula
D2	=IF((C2-7))
D3	=IF((C3-7))

 

[on3moy]

Use Days() Function. It returns the date into number of days. Then Subtract them and do a logical formula like so.
=IF(DAYS(End_Date,Start_DAte)>7,"Past Seven","")