Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am looking for a function or code to extract from a list , names of those
persons whose anuual fee payment due date is within next 15 days.This output list be a report or in a separate sheet which always reflect current status of the above function. Example :sheet 1 r/no -- col a------------col b----------------------------col c 1 ---name----------membership date--------------annual fee 2. ----david----------09-feb-2003--------------------$60 3. ------mark----------08-jan-2001--------------------$50 4. ------rosy-----------*********--------------------*** 5. ------cary-----------05-jan-2004---------------------$45 6. ------james---------11-nov-2005---------------------$80 (note: all in the list are not necessarily members) What I need is:(as on today) r/no-----col a--------------col b 1.-------name-------------Due date 2.-------cary--------------05-jan-2006 3.-------mark-------------08-jan-2006 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
cell color change based on due date | New Users to Excel | |||
Last Date in List | Excel Discussion (Misc queries) | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |