Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE help with difficult problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE help with difficult problem
Let's do this in steps.
1) To calculate the different dates do this 6 weeks from date in A1 =A1 + 6 * 7 formatted as date 3 months from date in A1 =Date(YEAR(A1),MONTH(A1)+3,Day(A1)) 9 and 13 months is the same as above, except change + 3 to + 9 or + 13 When you have that done, come back and we can talk you through the rest. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "caseysmydog" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE help with difficult problem
-- David "Barb Reinhardt" wrote: Let's do this in steps. 1) To calculate the different dates do this 6 weeks from date in A1 =A1 + 6 * 7 formatted as date 3 months from date in A1 =Date(YEAR(A1),MONTH(A1)+3,Day(A1)) 9 and 13 months is the same as above, except change + 3 to + 9 or + 13 When you have that done, come back and we can talk you through the rest. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "caseysmydog" wrote: 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 Barb... Works great! Now here's what this looks like & a question. abc D E F G H I 1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths 2 3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09 Question: we will have about 200 entries. Do I have to manually enter the formulas changing D progressively each time. That would be 5 formulas across for each line (entry/person) Then, we can address how to pull information and sort. Thanks, David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE help with difficult problem
What you need to do is select the first row of cells to copy. In the lower
right corner of the group of cells, you'll see a small square. Put your cursor on the square, click the mouse button and drag down. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "caseysmydog" wrote: -- David "Barb Reinhardt" wrote: Let's do this in steps. 1) To calculate the different dates do this 6 weeks from date in A1 =A1 + 6 * 7 formatted as date 3 months from date in A1 =Date(YEAR(A1),MONTH(A1)+3,Day(A1)) 9 and 13 months is the same as above, except change + 3 to + 9 or + 13 When you have that done, come back and we can talk you through the rest. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "caseysmydog" wrote: 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 Barb... Works great! Now here's what this looks like & a question. abc D E F G H I 1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths 2 3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09 Question: we will have about 200 entries. Do I have to manually enter the formulas changing D progressively each time. That would be 5 formulas across for each line (entry/person) Then, we can address how to pull information and sort. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |