[ExcelVBA] Formula from 2003 to 2010

 

The below formula worked great in an Excel 2003 file, but after converting to 2010, the formula returns 1/0/00 0:00 instead of the Now() date and time. I have formatted the cells for the proper format.

Typically, if data was entered into D4, then the timestamp would populate into E4. If nothing was entered, the cell was blank.

Can anyone tell me how to fix this? I realize it isn't VBA, but thought someone may be able to assist.

=IF(D4<>"",IF(E4="",NOW(),E4),"")

Thanks
Sharron

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___