PLEASE help with difficult problem

[caseysmydog]

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

 

[Barb Reinhardt]

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.

 

[caseysmydog]

--
David

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.

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

 

[Barb Reinhardt]

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.