Re: Activity Completion Report Formatting by Rick Jerz - Saturday, 15 August 2020, 3:44 AM Number of replies: 0 You would need a function to extract the date as you desire. Did you search the Internet for "Excel extract date from text date"? Average of ratings: Useful (2) Permalink Show parent Reply