Thread: Excel date or edate function help
View Single Post
 
Old 07-17-2013, 06:01 AM
CGM3 CGM3 is offline Windows XP 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, 7 views)
Reply With Quote