by Ilker | Nov 19, 2018 | Excel Formulas, Resources
Excel DATEVALUE function returns a date serial number from a specified date that is stored as text. This function comes in handy when your dates are stored as text data, instead of Excel’s date number format. In this guide, we’re going to show you how to use the...
by Ilker | Nov 19, 2018 | Excel Formulas, Resources
The DATE function in Excel returns a date serial number from specified year, month and day values. In this guide, we’re going to show you how to use the DATE function and also throw in some tips and error handling methods. Supported versions All Excel versions Date...
by Ilker | Nov 13, 2018 | Excel Formulas
The Excel YEAR function returns the year from a specified date serial number. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Excel YEAR Function Syntax...
by Ilker | Nov 13, 2018 | Excel Formulas
The Excel MONTH function returns the month from a specified date serial number. In this guide, we’re going to show you how to use the this function and also throw in some tips and error handling methods. Supported versions All versions Excel MONTH Function Syntax...
by Ilker | Nov 13, 2018 | Excel Formulas
The DAY function in Excel returns the day from a specified date number. In this guide, we’re going to show you how to use this function and also include some tips and error handling methods. Supported versions All Excel versions DAY Function in Excel Syntax...
by Ilker | Jul 27, 2018 | Excel Formulas, Excel Tips & Tricks
Although Excel has a function to get week number of a date, WEEKNUM; there isn’t any to make reverse calculation. This method will help you answer the question – what week of the year is it, and give you the end date of each week. Syntax =MIN(DATE(current...
by Ilker | Jul 27, 2018 | Excel Formulas, Excel Tips & Tricks
Although Excel has a function to get week number of a date, WEEKNUM; there isn’t any to make reverse calculation. This method will help you answer the question – what week of the year is it, and give you the start date of each week. Syntax...
by Ilker | Jul 18, 2018 | Excel Formulas, Excel Tips & Tricks
When you need to calculate the difference between a time present day and the next day, calculations can get messed up and you will see lots of # characters. This article shows how to create a time calculator in Excel that can calculate shift time after midnight using...
by Ilker | Jul 13, 2018 | Excel Formulas, Excel Tips & Tricks
Calculating averages by week number is a bit different than doing this by month. Instead of finding start and end dates of date range, we focus on the exact week number using the WEEKNUM function. Syntax =AVERAGEIFS( range of values to calculate average, range of week...
