Date every tuesday

[Mat]

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

 

[Pete_UK]

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

 

[Mat]

Hi Pete_Uk,

Thank you very much.

Regards

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

 

[Pete_UK]

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

Pete