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

=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

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


"Dave Peterson" wrote in message
...
=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