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), "")

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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