| Computers Forum Index » Computer Applications - Spreadsheets » How Can I in office 2003... |
|
Page 1 of 1 |
|
| Author |
Message |
| rob e... |
 Posted: Wed Sep 10, 2008 4:29 pm |
|
|
|
Guest
|
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.. |
|
|
| Back to top |
|
|
|
| Jim Backus... |
| Posted: Tue Sep 16, 2008 10:20 pm |
|
|
|
Guest
|
On Wed, 10 Sep 2008 11:29:38 UTC, "rob e" <btb.102 at (no spam) ntlworld.com>
wrote:
Quote: 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 <dot> backus <the circle thingy> jita <dot>
demon <dot> co <dot> uk |
|
|
| Back to top |
|
|
|
|
