| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No date entered still pulls a reult '1' through??
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. -- Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No date entered still pulls a reult '1' through??
When the MONTH function refers to a blank cell, it treats its value as 0. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No date entered still pulls a reult '1' through??
Use your formula like the below:-
=IF(P145="","",MONTH(P145)) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Jim" wrote: 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. -- Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for returning date entered by date on another worksheet | Excel Worksheet Functions | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| Date subtraction -How to not show negative when 2nd date not entered | New Users to Excel | |||
| Need date to appear 90 days later than initial date entered | Excel Worksheet Functions | |||
| How to get reult in text | Excel Worksheet Functions | |||
Linear Mode
