Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-17-2013, 06:01 AM
CGM3 CGM3 is offline Excel date or edate function help Windows XP Excel date or edate function help Office 2007
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

Hmm, I have no problem (see attached).

Could the G9 cell be in text format (or displayed using the TEXT() function), or contain something like leading or trailing characters that would essentially make the value NOT a date/time?
Attached Files
File Type: xls DateTest.xls (22.0 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
If Function Challenge involving date no1texan Excel 6 07-15-2012 12:58 PM
Change format of date when using Now function in VB code Bondai Excel Programming 2 03-02-2012 05:09 PM
Excel date or edate function help Today's Date Function freschij Excel 3 02-11-2011 10:21 AM
Automatic Date Function Corrupting Printer Output Theodulf Word 0 05-28-2010 12:33 PM
Date Function in word? aligahk06 Word 1 04-21-2010 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft