Date function
 

Hi there,

I need a function that will take a text value of a month i.e. January and
turn it into a date of the 15th of that month so would equate to 15/01/2007

Date function
 

=--("15 "&A1&" 2007"), and format the cell appropriately.
--
David Biddulph

"Pasty" wrote in message
...
Hi there,

I need a function that will take a text value of a month i.e. January and
turn it into a date of the 15th of that month so would equate to
15/01/2007