Hi,
I have a date stored in the following format: mmddyyyy in cell Y2. I am trying to reference that date in a formula I am using in cell X2 to build a directory path. When I reference the date in Y2 it displays in a different format.
For example: The date in cell Y2 is 06112011 but when I reference it in X2 it displays as 40705.
How do I change this so it pulls in 06112011 in my formula in X2?
I've attached a spreadsheet with the formula I am building.
Thanks in advance!
Bookmarks