Date Correction

[sachar]

Dear All,

With reference to the attach sample file which have converted from PDF to EXCEL but, I am looking the [column”D”] is present the wrong date “Date as a Year” and, “Year as a Date”.

Please help to make correct this.

Thanks for any help.

 

[John Jairo V]

Hi @sachar

You can use this formula in a next cell:
=DATE(2000+DAY(D3),MONTH(D3),YEAR(D3)-2000)
And drag it down.

Blessings!

 

[sachar]

Dear John,

Very simple! thanks.