Dear Friends,

I need to write the date of every Tuesday next to the member name for the
whole year 2007 and 2008. Example


Name July 8, 2008 July 15, 2008 July 22, 2008 July 29, 2008
Mr. A
Mr. B
Mr. C
Mr. D
Mr. E


Can we write any formula for this.

Friend in need.

Mat

If you put a Tuesday date in B1, for example, you can put this in C1:

=B1+7

and copy this across to give you successive Tuesdays.

Hope this helps.

Pete

On Jul 7, 2:30*pm, Mat <M...@discussions.microsoft.com> wrote:
> Dear Friends,
>
> I need to write the date of every Tuesday next to the member name for the
> whole year 2007 and 2008. Example
>
> Name * *July 8, 2008 July 15, 2008 July 22, 2008 July 29, 2008
> Mr. A * * * * * * * * * * * * *
> Mr. B * * * * * * * * * * * * *
> Mr. C * * * * * * * * * * * * *
> Mr. D * * * * * * * * * * * * *
> Mr. E * * * * * * * * * * * * *
>
> Can we write any formula for this.
>
> Friend in need.
>
> Mat

Hi Pete_Uk,

Thank you very much.

Regards

mat

"Pete_UK" wrote:

> If you put a Tuesday date in B1, for example, you can put this in C1:
>
> =B1+7
>
> and copy this across to give you successive Tuesdays.
>
> Hope this helps.
>
> Pete
>
> On Jul 7, 2:30 pm, Mat <M...@discussions.microsoft.com> wrote:
> > Dear Friends,
> >
> > I need to write the date of every Tuesday next to the member name for the
> > whole year 2007 and 2008. Example
> >
> > Name July 8, 2008 July 15, 2008 July 22, 2008 July 29, 2008
> > Mr. A
> > Mr. B
> > Mr. C
> > Mr. D
> > Mr. E
> >
> > Can we write any formula for this.
> >
> > Friend in need.
> >
> > Mat
>
>

You're welcome, Mat - thanks for feeding back.

Pete

On Jul 7, 4:35*pm, Mat <M...@discussions.microsoft.com> wrote:
> Hi Pete_Uk,
>
> Thank you very much.
>
> Regards
>
> mat
>