Jan 15 2020 01:48 AM - edited Jan 15 2020 01:49 AM
Dear all,,
help
i want to update date daily according to todays date
or get date from a reference cell
how can i do it ?
=INDEX('[PRESCREENING JANUARY-2020.xlsx]14-01-2020'!K:K,MATCH($N$7,'[PRESCREENING JANUARY-2020.xlsx]14-01-2020'!A:A,0))