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, 07:58 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

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

Reply With Quote