answersLogoWhite

0

How do you get dates in Excel?

User Avatar

Anonymous

10y ago
Updated: 8/20/2019

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:

=DATE(2005,12,2)

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

Does Excel store dates and times using text?

No. Dates and times are stored as numbers in Excel.


Can you format dates in Excel?

yes


What Excel property help to design date in style?

Formatting. There are many ways of formatting dates in Excel.


When is the beginning of time in Excel?

In terms of dates, computers usually start dates for the 1st of January 1900. This is the way it works in Excel. For times, it starts at 00:00.


The default alignment for dates in MS Excel is?

Dates align to the right, because they are a type of number.


When is day 1 in Excel in PC?

All dates on Excel have a numeric value. The 1st of January 1900 has the value of 1. All dates are counted off from that date. By giving dates numeric values, it is possible to do calculations with dates, like finding how many days are between two dates.


Does Excel stores dates as sequential serial values?

Yes it does, for dates from the 1st of January 1900, but not before that.


Which Excel feature can be utilized to only allow the input of certain data such as dates times or numbers?

Validation is the feature that can limit what is entered into cells in Excel.


Excel aligns date entries at the what side of the column?

Dates are aligned to the right.


What is a sequential numbers dates times or text called in Excel?

They can be called a series.


Why are dates right-aligned within a worksheet cell by default?

Excel right aligns dates within a worksheet because it treats dates as numbers.


How do you get dates on Excel sheet?

You can use the NOW(), DATE() or TODAY() functions. You can type Ctrl and the ; to get today's date. You can just type dates in.