Excel
 

I would like a way for excel to type the date of every thursday of this year
into cells?

Any ideas on this?

Thank you

Excel
 

Into A1, you could use the formula ="1/1/06"+5-WEEKDAY("1/1/06") to get the
first Thursday of the year, than =A1+7 in A2 & copy down for 50 more rows.
--
David Biddulph

"AF" wrote in message
...
I would like a way for excel to type the date of every thursday of this
year
into cells?

Any ideas on this?

Thank you

Excel
 

format column A as mm/dd/yyy
in A1 enter:
1/5/2006
in A2 enter:
=A1+7
and copy this thru A52
--
Gary's Student


"AF" wrote:

I would like a way for excel to type the date of every thursday of this year
into cells?

Any ideas on this?

Thank you

Excel
 

This year, meaning 2006?

In A1 enter:
1/5/06

In A2 enter:
1/12/06

Select *both* A1 and A2, and drag down as needed.

OR
In A1 enter:
1/5/06

In A2 enter:
=A1+7

And copy A2 down as needed.

The second option, using a formula, allows you to change the day (date) in
A1, and the dates (days) will subsequently change in the balance of the
column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AF" wrote in message
...
I would like a way for excel to type the date of every thursday of this
year
into cells?

Any ideas on this?

Thank you