Trevor Shuttleworth wrote:
Try:

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

Regards

Trevor

I have some formulas set up in a spreadsheet that other people will fill
progressively. In cells where the formula has no feeder' data to provide a
[quoted text clipped - 15 lines]

thanks

Trevor thanks - not sure if i am doing something wron when I use that formula
it does come back with nothing there however in that cell since I have a date
in b2 the result in a1 should be 1. If there was no date in b2 then the
result should be "blank" any other suggestions

thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200603/1