Excel NOW Function | Excel One Minute Quick Reference

Posted on:  10/31/2021
Excel NOW Function |  Excel One Minute Quick Reference

The NOW function in Excel returns the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings. You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon.

NOW function in Excel

NOW function in Excel

YouTube video

Syntax for NOW

=NOW()

The NOW function syntax has no arguments.

Other Excel articles

Excel - Create a custom list to sort data

Excel - Create a custom list to sort data

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

How To Show Percentages In Stacked Column Chart In Excel

How To Show Percentages In Stacked Column Chart In Excel

Subtotal Command in Excel - automatically calculate subtotals and grand totals

Subtotal Command in Excel - automatically calculate subtotals and grand totals

Excel - How to use the Navigation pane for charts, tables, PivotTables, pictures, and worksheets

Excel - How to use the Navigation pane for charts, tables, PivotTables, pictures, and worksheets

Excel NOW Function |  Excel One Minute Quick Reference

Excel NOW Function | Excel One Minute Quick Reference

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories