Date not updating in excel worksheet

06 May

Quite often, Excel formats the newly inserted date according to your Windows default date settings, but sometimes it may leave it exactly as you typed.

The most obvious visual indication that Excel has recognized the date you've entered is its right-alignment in a cell as opposed to left-aligned text values.

date not updating in excel worksheet-13date not updating in excel worksheet-13

For example, do you want to enter a today's date in some report or invoice?If a date you've entered displays as a number of pound signs (#####) in a cell, most likely the cell is not wide enough to fit the entire date.To fix this, double-click the right border of the column to auto fit the date, or drag the right border to set the desired column width.TODAY uses the computer's serial date - which stores the current date and time as a number - as an argument.It obtains this information on the current date by reading the computer's clock.