nesting more than 7 if statements

Hi there, I've come across the problem of nesting more than 7 if statements.
This if what I've used up to now

Please Login or Register  to view this content.

But I need to add more. I've tried using

Please Login or Register  to view this content.

which apparently will allow more than 30 but returns a number in the cell not a dd/mm/yy date (even after trying format cell).

I know there's a way to write a custom formula in VBA but can't work out how to make = If main!C2="Bakery" then let this cell equal the date from the bakery column BUT if Main!C2="Produce" then let this cell value equal the date from the produce column.

Any help would be appreciated Thank you.

Good morning KAPearson

Your MS Office version is listed as 2003? Is this correct? If so, then Chip Pearson (any relative?) has an article on that very subject here.

If you have updated to 2007 / 2010 then this limit is no longer there.

HTH

DominicB

Thanks guys I'll try all those and see which works.