I am referencing the date in long format from sheet Information and placing in a formula under sheet Contract.
=("The scope of work will begin on " & Information!C3)
The date is August 30, 2017 on the Information sheet and is returning as 42977 on the Contract sheet.
How do I fix this?
Bookmarks