Friday, 11 April 2014

How to Enter Current Time and Date in Excel Sheet

For current time and date in Excel Sheet, Please Enter =now(),
For current data in Excel Sheet, Please Enter =TODAY().

Note: Above functions work for current time which means, date/time entered will be automatically updated once the sheet is refreshed or reopened.

For fixed date, you can select a cell and press [ctrl] + [;]
For fixed time, press [ctrl] + [shift] + [;]

No comments:

Post a Comment