A Drop of Excel - 06 | How to work with Dates in Excel
Dates in Excel seem to be a very troublesome area for many people. Some feel there are bugs in Excel, some just keep seeing errors while working with Dates.
Let’s clear all these issues and understand how to very easily use dates in Excel.
We will learn the following in the video,
Understand how a date should be so that Sort, Filter, Pivot, everything works properly.
Shortcut to format dates very quickly.
Add and subtract days from a date.
Get day’s name from a date.
Get month’s name from a date.
Today() function versus shortcut to get today’s date.
Use of Today() function.
Example file link
https://drive.google.com/file/d/1l9tm...
\ Previous video: • A Drop of Excel - 05 | How to create ...
/ Understanding of the data being used in the examples: • A Drop of Excel | Understanding the d...
Related Videos/Posts
Calculate time difference in Excel between 2 times -- • Calculate time difference in excel be...
Generate First 1st Date of current month using Today function in Excel -- • Generate First 1st Date of current mo...
Convert month number to month name -- • Convert Month Number to Month Name in...
