How Can I in office 2003

[Database Administrator]

hi all,

i am trying to do the following with a m/s spread/s..
i need to be able to change a month date (e.g. Sept 2008) and have a row of
day names ( monday 1st etc) change according to the month and length of
month.. its for a staff rota i am trying to build...

any help would be really app....

thanks in advance...

btw.. i have no vb experience..

[Database Administrator]

On Wed, 10 Sep 2008 11:29:38 UTC, "rob e"
wrote:

> hi all,
>
> i am trying to do the following with a m/s spread/s..
> i need to be able to change a month date (e.g. Sept 2008) and have a row of
> day names ( monday 1st etc) change according to the month and length of
> month.. its for a staff rota i am trying to build...
>
> any help would be really app....
>
> thanks in advance...
>
> btw.. i have no vb experience..
>
No VBA necessary.

AFAIK showing the date in conventional dd/mm/yyyy format or any other
is simply a question of applying the correct format.

So if column A contains dates formatted as dd/mm/yyyy, make column B
equal to column A but change the format. In Neo Office which is an
Open Office version for the Mac, a format code of 'NNNN D' produces a
result 'Tuesday 17' for today whereas 'DD MMM YY' would produce 17 Sep
08. The actual format codes for other spreadsheets may be different
but the principle is the same.

HTH
--
Jim Backus running OS/2 Warp 3 & 4, Mac OS X and Win98SE
bona fide replies to j backus jita
demon co uk