Find (Today-21) in a range of dates
I need to write a formula which will search a range of cells containing dates
and if any of those is greater than todays date less 21 days, then return the text "not due". This is for a customer data base which has home page showing all customers, and subsequent pages for indvidual customers. As contact dates are added for each customer on their own sheets, then the home page should show if they are due (or overdue) for a call |
=IF(MAX(rng)(TODAY()-21),"not due","due")
-- HTH RP (remove nothere from the email address if mailing direct) "JG" wrote in message ... I need to write a formula which will search a range of cells containing dates and if any of those is greater than todays date less 21 days, then return the text "not due". This is for a customer data base which has home page showing all customers, and subsequent pages for indvidual customers. As contact dates are added for each customer on their own sheets, then the home page should show if they are due (or overdue) for a call |
Thanks Bob, I should have said that I need the formula to indentify
individual named sheets, ie Smith. How do include that please. "Bob Phillips" wrote: =IF(MAX(rng)(TODAY()-21),"not due","due") -- HTH RP (remove nothere from the email address if mailing direct) "JG" wrote in message ... I need to write a formula which will search a range of cells containing dates and if any of those is greater than todays date less 21 days, then return the text "not due". This is for a customer data base which has home page showing all customers, and subsequent pages for indvidual customers. As contact dates are added for each customer on their own sheets, then the home page should show if they are due (or overdue) for a call |
=IF(MAX(Smith!rng)(TODAY()-21),"not due","due")
-- HTH RP (remove nothere from the email address if mailing direct) "JG" wrote in message ... Thanks Bob, I should have said that I need the formula to indentify individual named sheets, ie Smith. How do include that please. "Bob Phillips" wrote: =IF(MAX(rng)(TODAY()-21),"not due","due") -- HTH RP (remove nothere from the email address if mailing direct) "JG" wrote in message ... I need to write a formula which will search a range of cells containing dates and if any of those is greater than todays date less 21 days, then return the text "not due". This is for a customer data base which has home page showing all customers, and subsequent pages for indvidual customers. As contact dates are added for each customer on their own sheets, then the home page should show if they are due (or overdue) for a call |
Thanks Bob,
It worked fine Cheers Jim "Bob Phillips" wrote: =IF(MAX(Smith!rng)(TODAY()-21),"not due","due") -- HTH RP (remove nothere from the email address if mailing direct) "JG" wrote in message ... Thanks Bob, I should have said that I need the formula to indentify individual named sheets, ie Smith. How do include that please. "Bob Phillips" wrote: =IF(MAX(rng)(TODAY()-21),"not due","due") -- HTH RP (remove nothere from the email address if mailing direct) "JG" wrote in message ... I need to write a formula which will search a range of cells containing dates and if any of those is greater than todays date less 21 days, then return the text "not due". This is for a customer data base which has home page showing all customers, and subsequent pages for indvidual customers. As contact dates are added for each customer on their own sheets, then the home page should show if they are due (or overdue) for a call |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com