LinkBack URL
About LinkBacks
pscornelison 
Trying to update some old macro code for a customer. This used to work (they claim) but now returns "Year to Date As of 1/31/1900"
="Year to Date As of " &TEXT(EOMONTH(6/1/2011,0), "mm/dd/yyyy" )
Thanks.............SRC
Trying to update some old macro code for a customer. This used to work (they claim) but now returns "Year to Date As of 1/31/1900"
="Year to Date As of " &TEXT(EOMONTH(6/1/2011,0), "mm/dd/yyyy" )
Thanks.............SRC
6/1/2011 is being interpreted as 0.0029836 (ie. 6 divided by 1 divided by 2011, not a date).
="Year to Date As of " &TEXT(EOMONTH(DATE(2011,6,1),0), "mm/dd/yyyy")
Or
="Year to Date As of " &TEXT(DATE(2011,7,0), "mm/dd/yyyy")
Thanks Colin, this is perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks