View Single Post
  #3   Report Post  
Houm
 
Posts: n/a
Default


-----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?



.