For some reazon I can not reply in your space, but here is the answer for
'How to set up a cell in excel to automatically apply the date ?
=TODAY()
It is ok for next time, try not to write all text in capital letters as is
consider inconsiderate by some readers. Regards.