Date Functions in Microsoft Excel PDF
Document Details
Uploaded by Deleted User
2024
Tags
Summary
This document provides a guide to date functions in Microsoft Excel, covering various date-related formulas and their applications. It explains how to use different functions such as TODAY, DATE, DAY, MONTH, YEAR, NOW, EOMONTH, EDATE, DATEDIF, WEEKDAY, and WEEKNUM to perform calculations and analysis with dates and times in Excel. It is a great resource for learning and understanding date-related excel functions.
Full Transcript
Basic DATE functions in MICROSOFT EXCEL 1 1. TODAY() Return the current date formatted as a Date. 2 2. DATE() Return the number that represents the date in the Date-Time Code. =DATE(year, month, day) 3 3. DAY() Return the...
Basic DATE functions in MICROSOFT EXCEL 1 1. TODAY() Return the current date formatted as a Date. 2 2. DATE() Return the number that represents the date in the Date-Time Code. =DATE(year, month, day) 3 3. DAY() Return the day of the month, a number from 1 to 31 =DAY(serial_number) Convert Date in Serial Number from format cell as Number. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and September 8, 2024, is serial number 45,543 because it is 45,543 days after January 1, 1900. 4 4. MONTH() Return the month, a number from 1(January) to 12 (December) =MONTH(serial_number) Convert Date in Serial Number from format cell as Number. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and September 8, 2024, is serial number 5 45,543 because it is 45,543 days after January 1, 1900. 5. YEAR() Return the year of a date, an integer in the range 1900-9999 =YEAR(serial_number) Convert the Date in Serial Number from format cell as Number. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and September 8, 2024, is serial number 6 45,543 because it is 45,543 days after January 1, 1900. 6. NOW() Return the current date and time formatted as date and time =NOW() 7 7. EOMONTH() Return the serial number of the last day of the month before or after the specified number of months =EOMONTH(start_date,months) I have specified ‘0’ (Zero) for the Current Month. 8 8. EDATE() Return the serial number of the date that is the indicated number of months before or after the start date =EDATE(start_date,months) Here, I have placed two numbers which will show the date two months from the current date. 9 9. DATEDIF() Calculates the number of days, months, or years between two dates. =DATEDIF(start_date,end_date,unit) * Unit is the type of information that you want returned in Year, Month, and Day. No. of Days: =DATEDIF(C14,C15,"d") No. of Months: =DATEDIF(C14,C15,"m") No. of Years: 10 =DATEDIF(C14,C15,"y") 10. WEEKDAY() Return a number from 1 to 7 identifying the day of the week of a date =WEEKDAY(serial_number, [return_type]) * Return_Type is a number that determines the type of return value. 11 11. WEEKNUM() Returns the week number in the year. =WEEKNUM(serial_number, [return_type]) Return_Type a number that determines on which day the week begins. 12 Share & Like Thank You… 13
