Thread: If Month?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default If Month?

=TEXT(TODAY(),"mmm")
--
If this post helps click Yes
---------------
Jacob Skaria


"RJJ" wrote:

I am struggling with an If=Month formula. In its simplest form, A1:A12 is
January thru December. Cell C1 to show "If month (happens to be May of
course) than show "May". Next month the same cell (C1) will say June, and so
on.

Can't believe I'm struggling to get this to work?

Can you help?