A
AF
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
into cells?
Any ideas on this?
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
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.
first Thursday of the year, than =A1+7 in A2 & copy down for 50 more rows.
G
Gary''s Student
format column A as mm/dd/yyy
in A1 enter:
1/5/2006
in A2 enter:
=A1+7
and copy this thru A52
in A1 enter:
1/5/2006
in A2 enter:
=A1+7
and copy this thru A52
R
Ragdyer
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.
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.