if cell contains date, then month, else blank

		Microsoft Office Forums > Microsoft Excel > Excel
if cell contains date, then month, else blank

FAQ

Thread Tools

Display Modes

10-03-2016, 07:58 AM

Merlot

Windows 7 64bit if cell contains date, then month, else blank

Office 2010 64bit

Novice

Join Date: Dec 2015

Posts: 7

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 AM.