Return value only if it falls 'within the next two weeks'

[halesowenmum]

Hi all

In H3 is the date a task is due (formatted as a Date, I promise )
In O1 is =TODAY()

In Col I from row 3 down I want to repeat the date shown in H3 (but only if it's due within a fortnight from today's date). This can be 14 calendar days, not business working days, that'll be fine.

Is there a way of doing this - I'm sure there is, I just don't know how and hope you can help me here on the forum.

Many thanks indeed.

 

[Scott T]

Try

Excel 2010
	H	I	J	K	L	M	N	O
1								6/12/2018
2
3	7/7/2018
4	6/20/2018	6/20/2018
Sheet4

Cell Formulas
Range	Formula
O1	=TODAY()
I3	=IF($O$1+14>=H3,H3,"")
I4	=IF($O$1+14>=H4,H4,"")

 

[halesowenmum]

Thank you Scott T, this works perfectly.