Excel shortcuts

The Best Shortcuts for Today's Date in Excel

If you're like most people, you probably use Microsoft Excel on a daily basis. And if you're like most people, you probably wish there were more shortcuts to help you get your work done faster. Well, today is your lucky day! We've compiled a list of the best shortcuts for today's date in Excel.

To insert today's date in Excel, simply press Ctrl + ;. That's it! This shortcut will insert the current date in the format that is set in your regional settings. If you want to insert the date in a specific format, you can use the TEXT function. For example, to insert the date in the mm/dd/yyyy format, you would use the following formula:

=TEXT(TODAY(),"mm/dd/yyyy")

To insert the day of the week, you can use the WEEKDAY function. For example, to insert the day of the week in the dddd format, you would use the following formula:

=WEEKDAY(TODAY(),2)

To insert the day of the week in the ddd format, you would use the following formula:

=WEEKDAY(TODAY(),3)

To insert the day of the week in the dd format, you would use the following formula:

=WEEKDAY(TODAY(),4)

To insert the day of the week in the d format, you would use the following formula:

=WEEKDAY(TODAY(),5)

To insert the month of the year, you can use the MONTH function. For example, to insert the month in the mm format, you would use the following formula:

=MONTH(TODAY())

To insert the month in the mmmm format, you would use the following formula:

=TEXT(TODAY(),"mmmm")

To insert the month in the mmm format, you would use the following formula:

=TEXT(TODAY(),"mmm")

To insert the year, you can use the YEAR function. For example, to insert the year in the yyyy format, you would use the following formula:

=YEAR(TODAY())

To insert the year in the yy format, you would use the following formula:

=RIGHT(YEAR(TODAY()),2)

To insert the date in the mm/dd/yyyy format, you can use the DATE function. For example, to insert the date in the mm/dd/yyyy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the dd/mm/yyyy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the yyyy/mm/dd format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the mm-dd-yyyy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the dd-mm-yyyy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the yyyy-mm-dd format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the mm/dd/yy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the dd/mm/yy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the yy/mm/dd format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the mm-dd-yy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the dd-mm-yy format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the date in the yy-mm-dd format, you would use the following formula:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

To insert the time, you can use the TIME function. For example, to insert the time in the hh:mm:ss format, you would use the following formula:

=TIME(HOUR(TODAY()),MINUTE(TODAY()),SECOND(TODAY()))

To insert the time in the hh:mm format, you would use the following formula:

=TIME(HOUR(TODAY()),MINUTE(TODAY()),0)

To insert the time in the hh:mm:ss AM/PM format, you would use the following formula:

=TIME(HOUR(TODAY()),MINUTE(TODAY()),SECOND(TODAY()))

To insert the time in the hh:mm AM/PM format, you would use the following formula:

=TIME(HOUR(TODAY()),MINUTE(TODAY()),0)

To insert the time in the hh:mm:ss format, you can use the NOW function. For example, to insert the time in the hh:mm:ss format, you would use the following formula:

=NOW()

To insert the time in the hh:mm format, you would use the following formula:

=NOW()

To insert the time in the hh:mm:ss AM/PM format, you would use the following formula:

=NOW()

To insert the time in the hh:mm AM/PM format, you would use the following formula:

=NOW()</

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.