Display the name of month from a range of dates

[hermithead]

I have created a spread sheet that records monthly tasks. Each task has been given a due date for completion. When I filter on the due dates for February I would like to have "February 2015" displayed in a cell above that task list as a header. I can then print this off as a Task list for February 2015. Or if I filter on September the cell would display "September" and so on. If the dates have not been filtered it would be nice for it display the current month but I can live without this.

I have tried using the Average function but despite the formula result displaying correctly in the Function Argument window it instead displays as "Jan-00" in the cell.

[[email protected]]

Use below formula
=subtotal(1,date_range) this will give you the month name

if you want in different format then use text function

=text(subtotal(1,date_range),"mmm-yy")

Regards,
Suhas

[Glenn Kennedy]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[hermithead]

Thankyou Suhas.