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:

Received	Type	collected
2/20/19	swab	15/02/2019
21/02/2019	swab	12/02/2019

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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","")