|
|
USe this instead
=TEXT(NOW(),"mmmm")
"Houm" wrote in message
...
Thanks. But how come it show as January instead of the
current month as April.
-----Original Message-----
Hi
=TEXT(MONTH(NOW()),"mmmm")
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Houm" wrote in message
...
-----Original Message-----
"Houm" wrote in message
. ..
Hi,
I would like to creat a functions that one of the
cell automatic fill as current month. Example the
foramt
as " January " and other cell auto fill with current
year?
what function should I use?
Any help would be very appreciated.
=YEAR(NOW())
=MONTH(NOW())
/Fredrik
Thanks for the answer. But hwo can I use the Format
function to show as month of April instead of show as
number 4?
.
.
|