if cell contains date, then month, else blank

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

10-03-2016, 03:27 PM

jeffreybrown jeffreybrown is offline

Windows Vista if cell contains date, then month, else blank

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

Try...

=IF(N(A37),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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 AM.