i'm new to excel i've mostly dealt with access for my database needs.so i dont know the functions that excel can handle.Does anyone know how to make excel show the header date as the [current date ...

Use either keyboard shortcuts or the NOW and TODAY functions to display the current date and time in Excel and Google Sheets spreadsheets together.