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] + [;]
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