Thread: month function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_834_] Rick Rothstein \(MVP - VB\)[_834_] is offline
external usenet poster
 
Posts: 1
Default month function

This should work...

=TEXT(28*A1,"mmmm")

where A1 contains your month number; of course, you could use the number, or
a calculation that results in the number, directly...

=TEXT(28*12,"mmmm")

Rick


"jordanpcpre" wrote in message
...
Is there a way to use the month function so that if 12 is inputed,
December
will be the output? Rather than the reverse. I tried

=Month(12)

but that doesn't return December. Could you help me please?! Thanks!