| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Has anybody figured this out yet?
Given that 'Date of service' is in column 'A' and 'Date of mailing' is
in column 'E'. Add the formula =TODAY()-365 to cell G2 add the formula =AND($A2<$G2,$E2<$G$2) to cell F2 Drag the formula in F2 down as far as required. 'TRUE' will be displayed when a reminder is needed - e.g when BOTH the service and mailing dates are a year old. Hope this helps Kev |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get to bottom right corner of window to resize? I figured it | Excel Discussion (Misc queries) | |||
| I figured out how to do total averages in Pivot Charts! | Charts and Charting in Excel | |||
| Still haven't figured this one out | Excel Discussion (Misc queries) | |||
| HELP!!! Can't get forumla figured out! | Excel Discussion (Misc queries) | |||
| I figured everything out except what "FALSE" does. | Excel Discussion (Misc queries) | |||
Linear Mode
