There are many possible solutions. Please post a sample sheet (no pics please) where the patient's name/ ID have been anonymized, but without changes to the dates, as they might be text looking like dates, not real dates ( formatting is how dates are presented to the outside world, it's the underlying data that is important.
If, after removing eventual manual alignments, your dates are left aligned in the cell, they are text ( although they look OK) requiring some additional treatment
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|