ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Has anybody figured this out yet? (https://www.excelbanter.com/excel-programming/275421-re-has-anybody-figured-out-yet.html)

Kevin

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


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com