Want to end up with any format other than Microsoft's 5 digit date number.
In this formula =a1&" thru "&a5, a1 reads 03-10-2013 and a5 which will always be 27 days after a1 reads 04-06-2013.
But the output of =a1&" thru "&a5 is 41343 thru 41370 instead of the non microsoft date format the cell is formatted for.
Question - How do i get what I want?
Thanks
Bookmarks