by Ilker | Jun 26, 2019 | Excel Formulas
The Excel ISBLANK function is an Information formula that returns TRUE if the reference cell is completely empty, and FALSE otherwise. As the name suggests, the formula asks the “Is X blank?” question to its argument. Although a cell must be completely...
by Ilker | Jun 26, 2019 | Excel Formulas
The Excel CONVERT function is an Engineering function that converts a number between unit systems. You can convert feet into meters, pounds into kilograms, gallons into liters Fahrenheit into Celsius, and so on with this formula. In this guide, we’re going to show you...
by Ilker | Jun 24, 2019 | Excel Formulas
The NETWORKDAYS.INTL is a Date & Time function that calculates and returns the number of business days between two given dates. The NETWORKDAYS.INTL function allows you to specify which days of the week are weekends and also use a list of holidays. In this guide,...
by Ilker | Jun 21, 2019 | Excel Formulas
The Excel NETWORKDAYS function is a Date & Time formula that calculates the number of work days between dates. The function excludes weekends by default, and can also be set in a way to exclude a number of holidays. In this guide, we’re going to show you how to...
by Ilker | Jun 20, 2019 | Excel Formulas
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...
by Ilker | Jun 20, 2019 | Excel Formulas
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...
by Ilker | Jun 19, 2019 | Excel Formulas
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...
by Ilker | Jun 17, 2019 | Excel Formulas
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...
by Ilker | Jun 16, 2019 | Excel Formulas
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...
