IDCrewDawg,

Reply to this message, and take the spaces out of my email address, and change the dot to .

HTH,
Bernie
MS Excel MVP


"IDCrewDawg" wrote in message
...

Bernie, thanks for all the help! My cells are in a row rather than a
colum. I want to put this information into cell 035 P35 Q35. If you
give me your email address I could mail it to you, so you can see what
I am trying to do.

Bernie Deitrick Wrote:
IDCrewDawg,

How about this? In O35, enter the formula

=IF(MONTH(DATE(YEAR($B$25),MONTH($B$25)+1,ROW()-6))=MONTH($B$34),DATE(YEAR($B$25),MONTH($B$25)+1,R OW()-6),"")

all on one row (your newsreader may wrap the text)
and copy to O7:O37 (I'm assuming your month's dates are all in a
column)

HTH,
Bernie
MS Excel MVP




--
IDCrewDawg
------------------------------------------------------------------------
IDCrewDawg's Profile: http://www.excelforum.com/member.php...o&userid=27009
View this thread: http://www.excelforum.com/showthread...hreadid=420861