How do I enter a date in MS Excel?

Type the date (for example, 2/2), then select Short Date or Long Date from the Home > Number Format option (in the Number tab). To insert the time, go to Home > Number Format menu (in the Number tab) >Time and type the time.

How do you insert date in YYYY MM DD format?

To format the date and time data types from a date column (date, DateTime, datetime2, smalldatetime, datetimeoffset, etc. ), use the FORMAT function. Use SELECT FORMAT (getdate(), 'dd/MM/yyyy ') as the date to get DD/MM/YYYYY.

Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

What is IF Condition and How to Use it

6m 25s

What is VLOOKUP and How to Use It

5m 59s

What is VLOOKUP Exact

4m 9s

How to Use COUNT IF

4m 23s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

How to Create Pivot Table in MS Excel

11m 6s

How to Manipulate Pivot Table

8m 19s

How to Add Slicers

4m 36s

How to Perform Grouping of Pivot Table

4m 39s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

How to Enter Date-Time

MS Excel in Bangla Data Entry

Enroll Now For Free

Discussion

Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

What is IF Condition and How to Use it

6m 25s

What is VLOOKUP and How to Use It

5m 59s

What is VLOOKUP Exact

4m 9s

How to Use COUNT IF

4m 23s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

How to Create Pivot Table in MS Excel

11m 6s

How to Manipulate Pivot Table

8m 19s

How to Add Slicers

4m 36s

How to Perform Grouping of Pivot Table

4m 39s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

FAQs

Choose the cell where the current date or time should be entered. To insert the current date, use the shortcut Ctrl + ; (Control + semicolon). To insert the current time, use Ctrl + Shift + ; (Control + Shift + semicolon). Use the combo (Ctrl + ;) as a shortcut.

The quickest way to do this is to press Shift+Ctrl+; (that's a semicolon) in Excel's built-in shortcut for entering the current time. You'll see the current time as you want it if the cell is configured to show times in 24-hour format.

Type the date (for example, 2/2), then select Short Date or Long Date from the Home > Number Format option (in the Number tab).
To insert the time, go to Home > Number Format menu (in the Number tab) >Time and type the time.

To format the date and time data types from a date column (date, DateTime, datetime2, smalldatetime, datetimeoffset, etc. ), use the FORMAT function.
Use SELECT FORMAT (getdate(), 'dd/MM/yyyy ') as the date to get DD/MM/YYYYY.