by Ilker | May 18, 2018 | Excel Formulas
If you want to convert a number to time values, you need some additional operations, multiplying and dividing between days, hours, minutes, and seconds. Here, we’re going to take a look at a simpler approach by using Excel’s TEXT function. Syntax...
by Ilker | Apr 11, 2018 | Excel Formulas, Excel Tips & Tricks
Be it for creating a time card or planning, creating a flexible calendar where you can omit holidays will come in very handy. Using the WORKDAY function you can easily create such a table and incorporate it in your data models. Syntax =WORKDAY(previous date, 1) Steps...
by Ilker | Apr 5, 2018 | Excel Formulas, Excel Tips & Tricks
Working with dates in Excel can be a bit challenging at times, because Excel doesn’t use dates as we conceive it. Knowing how Excel handles dates, you will find it pretty easy to use them in calculations and reports. Syntax =date + days Steps Select or type in...
by Ilker | Apr 2, 2018 | Excel Tips & Tricks
A quick and easy way to count between dates is by using the COUNTIFS formula. Create formula-based filters, find your sales figures, or organize your tables in no time. Syntax =COUNTIFS(date range, >=minimum date, date range, =1/1/2012” Add the date range again...
by Ilker | Mar 29, 2018 | Excel Formulas, Excel Tips & Tricks
How much did you spend until last year, or what is the total of X until Y? SUMIF and SUMIFS functions can help you to sum values in your data tables. Syntax =SUMIFS(values to sum range, date...
