ExcelBanter - formula problems

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula problems (https://www.excelbanter.com/excel-worksheet-functions/57378-formula-problems.html)

Ted

formula problems

Hi, I have the date a job was entered into excel in cell C3. I have the
current date displayed in E3. I want to remove any jobs that are older than
two weeks.

What formula can do that, and how can it be incorporated within the below
formula please??

=IF(AND(C3<D3,COUNT(C3:D3)=2),IF(ROUND(7/(C3-D3),5)0.5,ROUND(7/(C3-D3),5),""),"")

Thanks, Ted.

All times are GMT +1. The time now is 03:13 AM.