Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We are a church who needs help..we realize it will take much time and we
would be so grateful. Here's our situation: Currently have a chart as follows, Name, Date Joined, 6 weeks(from date joined), 3 months, 6 months, 9 months, 13 months. We need Excel to figure and place in each column the date calculated from date joined, for instance, 6 weeks from date joined, 3 months from date joined and so on. Date is xx/xx/xx. After this is completed for all members, we then need to process the whole file each month to see who matches the the time for each column. For instance: If Mike Smith has been a member for 6 weeks, move his name and 6 weeks date to print, and each field would be tested all all members and if they met the match between date joined and time frame in any across date columns, their name and date would print out. Also, could this be sorted by name and everything kept together? Thanks so much for your help David -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Little Problem, Difficult and Hard. | Excel Discussion (Misc queries) | |||
A difficult problem - Excel 97 | Excel Discussion (Misc queries) | |||
a difficult problem | Excel Programming | |||
Difficult Excel Problem | Excel Worksheet Functions | |||
difficult problem | Excel Programming |