Turn Value into Month
Is there a way I can convert 1 -> January 2-> February .... 12 -> December?
I have a group Month, and group Day, I would like to be able to format it so that instead of saying 2, it will say "February"
How can this be accomplished?
Thanks,
Mike
February 8th, 2011 2:49pm
hello, you can use the monthname function
=monthname(1) will return "January" and so forth
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2011 2:56pm