ExcelBanter - View Single Post

Ron Rosenfeld

On Tue, 4 Mar 2008 12:44:11 -0800 (PST), wrote:

Brilliant Thank you to both of you.

I'll push my luck now!, is there any easy way to get e.g. 01/02/08 or
01-Feb-08 to change to Feb so that in my previous example its sees
them both as the same thing and not formated to be that. I have tried
using =month(a1) but it doesnt always seem to return the correct
Month. So am having to type in the related month. This is ok except
if the core data changes it will not automatically update.

Thanks again for all your help

Mags

Let us assume that

C1: 2

for February.

You could then use MONTH(Month)=C1 to ensure the month is the same.
--ron