|I'm a bit confused by your subject line vs. what is in your actual post.|
If you simply want to identify which dates are Sunday, use something like this formula next to your dates:
Review the Excel Help files on the WEEKDAY function for more information.
There are other Date and Time functions that might be helpful.
Enter Date and Time Functions in the Excel Help search field for a list.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.