T
Ted
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
3)=2),IF(ROUND(7/(C3-D3),5)>0.5,ROUND(7/(C3-D3),5),""),"")
Thanks, Ted.
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
3)=2),IF(ROUND(7/(C3-D3),5)>0.5,ROUND(7/(C3-D3),5),""),"")Thanks, Ted.