ANALYTICS TRAINING HUB

The Excel DATE function returns the date in the Excel recognized serial number format that represents a date. It returns the date based on individual year, month and day components you specify. It is one of the main functions to calculate the dates in Microsoft Excel. Read More..

The Excel MONTH function returns the serial number corresponding to a month of a date ranging from 1 (January) to 12 (December). In other words, MONTH function extracts the month value from a date in a cell. Read More..

The Excel YEAR function returns a 4-digit integer representing the year corresponding to a specified date. A 4-digit year of the date is returned as an integer in the range 1900-9999. Read more..

The Excel DAY function returns the day of the month from a supplied date as an integer ranging from 1 to 31. In other words, using DAY function, you can find out the day of the month that corresponds to a given date. Read More...