Microsoft Office Forums - View Single Post - if cell contains date, then month, else blank

Thread: if cell contains date, then month, else blank

View Single Post

Old

10-03-2016, 11:49 AM

Merlot

Merlot is offline

Merlot uses Windows 7 64bit

Windows 7 64bit Merlot uses Office 2010 64bit

Merlot uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Dec 2015

Posts: 7

Merlot is on a distinguished road

Default

Hi,

I tried this =IF(OR(A37="",ISTEXT(A37)),"",MONTH(A37)) and it is working. Thanks though.

Reply With Quote