if cell contains date, then month, else blank

ArviLaanemets · #8 03-19-2025, 12:19 PM

What is really the value in cell A37?
Is it a date, and the cell is formatted as "mm,dd,yyyy"?
When yes, then (as dates in Excel really are positive numbers)

Code:

=IF(A37>0, MONTH(A37), "")

Or is it a datestring either entered/copied into call manually, or the result of FORMAT(function)?
When yes, then (assumed "mm,dd,yyyy" is a valid date format for your local settings, but you can handle non-valid values with IFERROR() when there is a possibility for it)

Code:

=IF(IFERROR(DATEVALUE(A37),0)>0, 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