Trevor Shuttleworth wrote:
You said:

Cell A1 = 1(month from B1) correct
Cell B1 = 1/2/06

Hence, the formula for cell A1 to cope with cell B1 being blank is:

=IF(B1="","",Month(B1))

If Cell A2 relates to cell B2, as I assume it does, then the formula for A2
would be:

=IF(B2="","",Month(B2))

And so on. You can AutoFill the formula down the column or just copy and
paste and the formula will adjust.

So:
A3 =IF(B3="","",Month(B3))
A4 =IF(B4="","",Month(B4))
A5 =IF(B5="","",Month(B5))

Maybe I have misunderstood what you are trying to achieve

Regards

Trevor

Try:

[quoted text clipped - 19 lines]

thanks


You are the best!!!!!!!!!!!!!!!!!!!!!!!!!!

thanks

--
Message posted via http://www.officekb.com