ExcelBanter - View Single Post

tinkertron

Could it be that the date and time on your system is not correctly set? Double click on your clock in your task bar tray and check the setting to make sure they are set correctly? These formula works off the information in your system.

Quote:

Originally Posted by Houm

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?

.

.