Hiya,

I'm using the =Date(D4,C4,C2) to generate a date from three cells. However, cell C4 reads as the moth in text as opposed to a number (e.g. April). any idea how I can overcome this problem without having to have a hidden cell with a long if/lookup formula?

Thanks