#1
|
|||
|
|||
if cell contains date, then month, else blank
I am trying to input a formula for if a cell contains a date then return the month's number else leave the cell blank.
I tried this: =IF(A37=(mmmm,dd,yyyy),MONTH(A37),"") The date in A37 is in this format : August 4, 2016 Thanks |
#2
|
||||
|
||||
What else can the cell contain?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
It can either contain the date, text or be blank
|
#4
|
|||
|
|||
Hi,
I tried this =IF(OR(A37="",ISTEXT(A37)),"",MONTH(A37)) and it is working. Thanks though. |
#5
|
|||
|
|||
Try...
=IF(N(A37),MONTH(A37),"") |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto update excel graph range, ignore data when date reads 00-Month-00 | SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
Filter by a Month that falls within a date range | MattG1225 | Excel | 2 | 12-03-2015 07:44 AM |
Formulato say if cell is blank do this, if not blank do this. | mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |