No date entered still pulls a reult '1' through??

J

Jim

In Excel 2007 i am using the formula =MONTH(P145) all the way down the
column, which if there is not date entry in columns that are not yet in use
the formula still pulls through a '1' which is mucking up all the
corrisponding information that is pulled for the month of Jan. Can anyone
advise me as to what i can do to get no result pulling through if there is
not a date entered into column P?
Thanks.
 
R

Ron Coderre

When the MONTH function refers to a blank cell, it treats its value a
0.
Date 0 (zero) translates to: Saturday, January 00, 1900
(it makes little sense, but that's the situation)

Consequently, =MONTH(P145) returns: 1

Try this:
=IF(B1>0,MONTH(P145),"")

Does that help
 
M

Ms-Exl-Learner

Use your formula like the below:-

=IF(P145="","",MONTH(P145))

Remember to Click Yes, if this post helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top