Updating date in excel
Help users increase productivity by automatically signing up for Tech Republic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
If the cell format was General before the function was entered, Excel changes the cell format to Date.
Be sure you don't use Columns A and B for any other data; otherwise, COUNTA will return an incorrect value.
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
I would like to stop editing the date everytime i need print an excel sheet!
So how could i add a formula to make the date shows update it automatically?