Date Range Attributed to Single Month

[gmr1974]

Hello,

I am looking for help on how to attribute various days throughout a month to a single month. For example, I have multiple date entries from January 1 2009 through January 31 2009. I would like to add a formula where the result is simply "January 2009" for all dates within that month. Is this possible?

Thank you,
GMR

 

[barry houdini]

Hello gmr1974, welcome to MrExcel,

You could do that by simply formatting the date to show just date month and year (although the underlying value will still be the actual date), or if you want a text value in another cell try using TEXT fuunction, e.g.

=TEXT(A1,"mmmm yyyy")

 

[gmr1974]

I can't believe I didn't think of the format.. I'm obviously making this WAY too hard Thank you so much!!!