Create a pseudo Calender?
 

I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial of each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.

Create a pseudo Calender?
 

In A3 type your start date (eg 01/01/2006) and format the cell as Custom
with Type as d.
In B3 type =A3+1
Copy this cell as far across as you need

In A2 type =LEFT(TEXT(WEEKDAY(A3),"ddd"),1)
Copy this cell across the sheet as far as you need.

Bear in mind that you wont be able to create a whole year in this way as
Excel only has 254 columns.

--
Ian
--
"StuartGB" wrote in message
...
I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial of
each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.

Create a pseudo Calender?
 

There are some neat ones here...
http://www.tushar-mehta.com/excel/te..._calendar.html

"StuartGB" wrote:

I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial of each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.

Create a pseudo Calender?
 

Ian,

Thanks, but not working for me. A3 value shown as 1, but B3 is 38719 where
formula is A3+1.
Using Excel 2003.
Did you custom format type d, or dd?

regards,
Stuart.

"Ian" wrote:

In A3 type your start date (eg 01/01/2006) and format the cell as Custom
with Type as d.
In B3 type =A3+1
Copy this cell as far across as you need

In A2 type =LEFT(TEXT(WEEKDAY(A3),"ddd"),1)
Copy this cell across the sheet as far as you need.

Bear in mind that you wont be able to create a whole year in this way as
Excel only has 254 columns.

--
Ian
--
"StuartGB" wrote in message
...
I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial of
each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.

Create a pseudo Calender?
 

Sorry, I forgot to add that you need to format each cell on row 3 the same
as A3. Copy A3, then paste specialformats to the rest of the row.

FYI, Excel stores dates a numbers starting from 1 Jan 1900 making your 38719
equivalent to 2 Jan 2006.

--
Ian
--
"StuartGB" wrote in message
...
Ian,

Thanks, but not working for me. A3 value shown as 1, but B3 is 38719 where
formula is A3+1.
Using Excel 2003.
Did you custom format type d, or dd?

regards,
Stuart.

"Ian" wrote:

In A3 type your start date (eg 01/01/2006) and format the cell as Custom
with Type as d.
In B3 type =A3+1
Copy this cell as far across as you need

In A2 type =LEFT(TEXT(WEEKDAY(A3),"ddd"),1)
Copy this cell across the sheet as far as you need.

Bear in mind that you wont be able to create a whole year in this way as
Excel only has 254 columns.

--
Ian
--
"StuartGB" wrote in message
...
I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial of
each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.

Create a pseudo Calender?
 

Works now.

Many thanks,Stuart.

"Ian" wrote:

Sorry, I forgot to add that you need to format each cell on row 3 the same
as A3. Copy A3, then paste specialformats to the rest of the row.

FYI, Excel stores dates a numbers starting from 1 Jan 1900 making your 38719
equivalent to 2 Jan 2006.

--
Ian
--
"StuartGB" wrote in message
...
Ian,

Thanks, but not working for me. A3 value shown as 1, but B3 is 38719 where
formula is A3+1.
Using Excel 2003.
Did you custom format type d, or dd?

regards,
Stuart.

"Ian" wrote:

In A3 type your start date (eg 01/01/2006) and format the cell as Custom
with Type as d.
In B3 type =A3+1
Copy this cell as far across as you need

In A2 type =LEFT(TEXT(WEEKDAY(A3),"ddd"),1)
Copy this cell across the sheet as far as you need.

Bear in mind that you wont be able to create a whole year in this way as
Excel only has 254 columns.

--
Ian
--
"StuartGB" wrote in message
...
I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial of
each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.

Create a pseudo Calender?
 

You're welcome.

Thanks for the feedback.

--
Ian
--
"StuartGB" wrote in message
...
Works now.

Many thanks,Stuart.

"Ian" wrote:

Sorry, I forgot to add that you need to format each cell on row 3 the
same
as A3. Copy A3, then paste specialformats to the rest of the row.

FYI, Excel stores dates a numbers starting from 1 Jan 1900 making your
38719
equivalent to 2 Jan 2006.

--
Ian
--
"StuartGB" wrote in message
...
Ian,

Thanks, but not working for me. A3 value shown as 1, but B3 is 38719
where
formula is A3+1.
Using Excel 2003.
Did you custom format type d, or dd?

regards,
Stuart.

"Ian" wrote:

In A3 type your start date (eg 01/01/2006) and format the cell as
Custom
with Type as d.
In B3 type =A3+1
Copy this cell as far across as you need

In A2 type =LEFT(TEXT(WEEKDAY(A3),"ddd"),1)
Copy this cell across the sheet as far as you need.

Bear in mind that you wont be able to create a whole year in this way
as
Excel only has 254 columns.

--
Ian
--
"StuartGB" wrote in message
...
I need to create a calender-type worksheet for 2006/2007.

All I actually need would be dates in row 3 with the first initial
of
each
day in the row above, eg:

M T W T F S S M
1 2 3 4 5 6 7 8 etc.

Is there a template available somewhere, please?

Regards,
Stuart.