Empty date cell shows wrong month & year

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
Empty date cell shows wrong month & year

Mark Forums Read

Prev

Previous Post

Next Post

Next

#3

Old

06-14-2019, 09:52 PM

xor

xor is offline

Empty date cell shows wrong month & year

Windows 10 Empty date cell shows wrong month & year

Empty date cell shows wrong month & year

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Isn't just

=IF(ISBLANK(A3),"",TEXT(A3,"mmm"))

Reply With Quote

« Previous Thread | Next Thread »

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
if cell contains date, then month, else blank	Merlot	Excel	7	03-20-2025 08:16 AM
can i make a dropdown style calender to select the month and year to enter vacation time taken	jamesbriese	Excel	1	12-06-2016 01:00 PM
Excel day date month year Function	greginky	Excel	1	01-05-2016 02:19 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 PM.