View Single Post
 
Old 03-19-2025, 12:19 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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), "")
Reply With Quote