Date every tuesday

  • Thread starter Thread starter Mat
  • Start date Start date
M

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
 
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
 
Hi Pete_Uk,

Thank you very much.

Regards

mat

Pete_UK said:
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
Click to expand...
 
Back
Top