LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JG
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count the number of dates in a range that are earlier than today. DeborahS Excel Worksheet Functions 1 March 9th 05 01:54 AM
How do I get Excell to sort dates that range from 1800 to 1900's Smith295 New Users to Excel 1 February 22nd 05 06:20 PM
Find number of days between to dates Qaspec Excel Worksheet Functions 1 January 21st 05 12:14 AM
Sum between a range of dates Bruce Excel Worksheet Functions 3 January 5th 05 02:25 AM
Use MATCH to find position of max in 2D range? Peter B Excel Worksheet Functions 4 October 28th 04 05:23 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"