 Function: DAYS360

The DAYS360 function is a Date & Time formula that calculates and returns the number of days between two given dates, based on a 360-day year (12 x 30 days per month). 360-day year base is used in some accounting calculations which assumes that 1-year period is... Function: WEEKNUM

The WEEKNUM is a Date & Time function that finds the week number of a given date. WEEKNUM function returns an integer indicating the week index according to the specified return type. In this guide, we’re going to show you how to use the WEEKNUM function and also... Function: WEEKDAY

The Excel WEEKDAY function is a Date & Time formula that finds the day of the week of a given date. The WEEKDAY function returns an integer indicating the day’s index according to the specified day of the week mapping scheme. In this guide, we’re going to... Function: EOMONTH

The EOMONTH Excel function (end of month) is a Date & Time formula that calculates and returns the serial date number of the last day of the month, for a certain number of months before or after a given date. EOMONTH function is useful for calculating maturity... Function: DAYS

The Excel DAYS function is a Date & Time formula that returns the number of days between dates (a start and end date). This can be very useful in finding the number of days to expiration, analyzing the time gap between sales, or really any other similar situation... How to monitor formulas using the Watch Window Excel feature

Do you have large datasets or dashboards with formulas scattered along multiple sheets? Are you navigating back and forth between sheets to check what the formulas return after changing values on the different sheets? Excel has a solution for you: the Watch window. In... How to Filter a Table in Excel

Data filters are essential for reporting and decision making. In Excel, you will get filter arrows by default when you create a new table. In this guide, we’re going to show you tips about how to filter Excel Tables. For more information about creating Excel... Function: EDATE

The Excel EDATE function is a Date & Time formula that calculates and returns the serial date number for a certain number of months before or after a given date. EDATE function is useful for calculating maturity dates or due dates that fall on the same day of the... Function: DATEDIF

The DATEDIF Excel function is a Date & Time formula that calculates and returns the number of days, months, and years difference between two dates. The DATEDIF function has been derived from Lotus 1-2-3 for compatibility, and is still kept in Excel for backwards...