| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
Hi,
Please can you help, I have a date in column A and a date in column B. In column C, I would like the work 'Ok' to appear if the difference between the two dates is +/- 2 weeks. If the difference between the dates is more than +/-weeks then the words 'not ok' to appear. Example: A B C 01/01/04 01/01/04 OK 01/01/04 15/01/04 Not OK 16/03/04 15/03/04 OK 16/03/04 01/03/04 Not Ok Thanks, Ward |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
Hi,
I don't understand why 01/01/04 15/01/04 Not OK evaluates as "Not OK" in you example but try this =IF(ABS(B1-A1)<=14,"OK","Not OK") Mike "Ward" wrote: Hi, Please can you help, I have a date in column A and a date in column B. In column C, I would like the work 'Ok' to appear if the difference between the two dates is +/- 2 weeks. If the difference between the dates is more than +/-weeks then the words 'not ok' to appear. Example: A B C 01/01/04 01/01/04 OK 01/01/04 15/01/04 Not OK 16/03/04 15/03/04 OK 16/03/04 01/03/04 Not Ok Thanks, Ward |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
Thank you,
sorry about the example - to much coffee "Mike H" wrote: Hi, I don't understand why 01/01/04 15/01/04 Not OK evaluates as "Not OK" in you example but try this =IF(ABS(B1-A1)<=14,"OK","Not OK") Mike "Ward" wrote: Hi, Please can you help, I have a date in column A and a date in column B. In column C, I would like the work 'Ok' to appear if the difference between the two dates is +/- 2 weeks. If the difference between the dates is more than +/-weeks then the words 'not ok' to appear. Example: A B C 01/01/04 01/01/04 OK 01/01/04 15/01/04 Not OK 16/03/04 15/03/04 OK 16/03/04 01/03/04 Not Ok Thanks, Ward |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
