On on sheet, I have the following formula in A1:
Formula:Please Login or Register to view this content.
I want this to return, for example, "From 7/1/2014 to 9/14/13"
My formula in B2 is (RunDateFrom is a named cell which can be any date, but if blank returns 7/1/2014):
and my B3 formula is (similarly, it's a named cell and if B3 is blank it returns today's date):Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
But A1 ends up displaying: "From 7/1/2014 to 41896" ...using the excel date number instead of the short date format for the last date.
Bookmarks