Thanks Dave. I'm a blond...what can I say?


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:437D33B6.64D13BDD@verizonXSPAM.net...
> =datevalue(a1&" 1, " & a2)
> format as a date
> (a1 holds the month name, a2 holds the year)
>
> (But July is usually the 7th month <vbg>.)
>
> Dino wrote:
>>
>> Anyone know of a way to combine a cell which contains a month name (July)
>> to
>> a cell that contains a year (2006) which results in a date 6/1/06?
>>
>> Thanks,
>> Dino
>
> --
>
> Dave Peterson