formula and functions

New Contributor

I am a beginner and would like some help with this please. I am not asking for the answer but if it could be explained how to do it. I have googled it but am stuck. thank you

2 Replies

@Smudge2020 

Normally, dates in Excel are right-aligned.

The values in A4:A10 are left-aligned. This suggests that Excel sees them not as dates, but as text values.

Can you think of a way to convert them to 'real' dates?

@Hans Vogelaar Thank you for your advise, I will see If I can solve this