Month return corresponding to all the date column wise

Hello Excel Captain

Month:

May-15*****01/05/2015 02/05/2015 03/05/2015 04/05/2015 05/05/2015 06/05/2015 07/05/2015 08/05/2015 09/05/2015 10/05/2015 11/05/2015 12/05/2015 13/05/2015 14/05/2015 15/05/2015 16/05/2015 17/05/2015 18/05/2015 19/05/2015 20/05/2015 21/05/2015 22/05/2015 23/05/2015 24/05/2015 25/05/2015 26/05/2015 27/05/2015 28/05/2015 29/05/2015 30/05/2015 31/05/2015

How do month return corresponding to all the dates column wise. file attached.

I need your help.

Do you mean that you want to fill those dates in columns B onwards if you put the month and year in column A?

Pete

its return for month.i need date respective from the month.

please help me.

See Richard's post #2.

Pete

A4=IF($A$2+ROWS($2:2)-1>EOMONTH($A$2,0),"",$A$2+ROWS($2:2)-1)

This formula working perfect row wise.The same was i need column wise.please help me.

Put this in B2:

=IF($A$2+COLUMNS($B:B)-1>EOMONTH($A$2,0),"",$A$2+COLUMNS($B:B)-1)

then copy across.

Hope this helps.

Pete

Great Peter Uk.

There was awesome

Glad to help - thanks for the rep.

Pete