Help with Excel formula please

Gers

Hi

Just trying to do a 'new to me' formula which I suspect is an 'IF' one but I am not sure.

I have three worksheets - for ease of use labelled A, B and C.

I want cell B2 in worksheet C to put 28 into it if cell B2 in worksheet B has a date in it. I can then copy it down the remainder of the cells

Is this doable? I'd appreciate some guidance on this please.

Thanks

bod1467

=IF(ISBLANK(B!B2),"",28)

would be the formula for cell B2 in worksheet C, although this checks whether B2 in worksheet B simply has a value. Unfortunately there isn't an ISDATE function so you'd need to look at nesting IF statements.

Gers

HUGE thanks for that - it's worked perfectly.

Le_Kirk

There is no function in Excel that will check for valid dates, just numbers. If you want a true test for valid dates your only recourse is to a vba function (visual basic) unless the answer given above will do you.

Gers

Le_Kirk wrote: »

There is no function in Excel that will check for valid dates, just numbers. If you want a true test for valid dates your only recourse is to a vba function (visual basic) unless the answer given above will do you.

Thanks - it wasn't for valid (?) dates, just A date is sufficient.

The formula has worked so I'm a happy bunny!