| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| self-updating formula | Excel Discussion (Misc queries) | |||
| Editing an existing formula | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Am trying to make a time sheet and having problems with a formula. | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
