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
drive.google.com/file/d/1l9tm...
\ Previous video: • A Drop of Excel - 05 |...
/ Understanding of the data being used in the examples: • A Drop of Excel | Unde...
Related Videos/Posts
- Calculate time difference in Excel between 2 times -- • Calculate time differe...
- Generate First 1st Date of current month using Today function in Excel -- • Generate First 1st Dat...
- Convert month number to month name -- • Convert Month Number t...
Пікірлер: 6
very well explained !
very informative
This is a great help. Thanks a ton. Wanted to know - if we have to calculate percentage of dates - like eg - between 01.01.2020 to 31.11.20 which date will be 60% of the time..?? Basically to calculate to shelf life..
@Excelrush
4 жыл бұрын
You will need to use =countif function to count number of occurrences of a particular date in the whole list, and then divide that count by the total number of dates to get the required %
@Excelrush
4 жыл бұрын
Let me know if you were able to do this?
as for the month part, i do exaclty tha same thing,insert the same code but as a result it gives me mmm, no the name of the month! what's the problem?