Excelbaba

How to add current Date & Time in Excel

If you want to add current date quickly then press shortcut key “Ctrl+;” and output gives you only current Date in excel cell.
If you want to add current date and time stamp then you will use pre-defined function “=Now()” in excel. Follow below mention steps.
  1. Click on cell where you want to add current date and time stamp
  2. Right click on the selected cell and press “Format Cells” option
  3. Select Category “Custom” and select type “General” then click “OK” button
  4. Then type “=Now()” on cell where you want to add Date and Time Stamp








































Excelbaba

About Excelbaba -

Author Description here.. Nulla sagittis convallis. Curabitur consequat. Quisque metus enim, venenatis fermentum, mollis in, porta et, nibh. Duis vulputate elit in elit. Mauris dictum libero id justo.

Subscribe to this Blog via Email :