Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Find number of days between to dates | Excel Worksheet Functions | |||
Sum between a range of dates | Excel Worksheet Functions | |||
Use MATCH to find position of max in 2D range? | Excel Worksheet Functions |