Hi Teylyn,

I just tired the above formula and it keeps returning a '0' when it shouldnt be as i have figures in Worksheet1 column B of the same date.

Do you know of any other way please.

Thank you