| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003; using a date in a formula
In cel B5 I have a date format; in cel L5 an ordernumber. I want Excel to
warn me if the date is 2 months (or more) later and if cel L5 is empty. this warning will be shown is a different cell, i.e. Q5. I am having trouble putting this in a formula or in conditional formatting. Can anyone help me out? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Validation - Excel 2003 | Excel Discussion (Misc queries) | |||
| date format in Excel 2003 | Excel Worksheet Functions | |||
| date format in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 formula to calculate date | Excel Worksheet Functions | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Threaded Mode
