0703 Date Formulas - DAY(), MONTH(), YEAR(), DATE()

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Hello there. This time we learn for form loss with respect to dates, simple formulas are mostly used in data analysis along with logical statements. Now, if you have a date already mentioned in one of the cells, there is a formula which is called D. What it does, it extracts the D that is third three. Now, although the formula parameter says CL number, but we are choosing a cell which contains a date, and if you remember from our earlier videos, every valid date is a number. So, I close the bracket and what I get is the formula D. Similarly, if I write equal m o n and press the Tab key, I'm going to choose the cell which contains the date close the bracket and what you get is a calendar month sequence for June which is six. Now, these formulas are generally used in combination with logical statements where you might say, if the month is less than or equal to six, which means January to June, then perhaps take a step away One If not, then take step two.

So, in terms of Formula year, what we get now is an uncertain year 2011. Now, at times if you are getting a data in text format where the date month and year are separated by a certain value, you may be getting those in different columns when you export to Excel. How do you combine these components into one single cell, which then is understood by Excel as date, the formula to be written in that case is date. Let me write in the correct cell equal to d ay t tacky. First, it asks for your which I gladly choose comma, then month, comma, and then followed by D. I choose the last parameter I close the bracket I press Enter. And once I do that, by default, it shows me the date in the MD vi format, which is the default setting for the specie if I do Then choose this date, I press Ctrl Shift three, it quickly changes it back to a format which not only shows the date but also the month in JN format.

So those were four formulas day, month, year and date formula

Sign Up