Hi there,

You are correct,the date formats are US. This is genrated from the system providing the data and can not be changed. My version of excel is set to read these correctly.

As per my original question the first part of the process is to identify all week ending dates for timesheets from Sart date to End date, but to only look for timesheets up to the date the report is being run.

Sorry it wasn't very clear.

Marshybid