Excel 2013: three new functions

DAYS()

Date arithmetic is nothing new in Excel, but this function is new to Excel 2013. Previously one had to use a formula like “=B1-A1” where B1 would contain the later date, A1 the earlier date. Typing “=DAYS(“ in a cell, you are prompted with “end_date,start_date”), for the formula
=DAYS(B1;A1)

It’s not any quicker than the old way, but it is more memorable. On your system, you may need a comma in place of a semi-colon (it’s a Regional setting in Windows).

exceldays.png

ARABIC()

We have long been able to use the ROMAN() function to create Roman numerals, but Microsoft has finally included its opposite:

excelarabic.png

ISOWEEKNUM()

Old (WEEKNUM) and New. Here are two formulas for week numbers, with results on the right:

excelISOWeek.png

ISOWEEKNUM() differs in what it sees to the first Monday of the year.

 
0
Kudos
 
0
Kudos

Now read this

Excel: Dynamic Summing To-Date

Here is our example spreadsheet: The SUM formula in cell B15 is shown. It uses MONTH(NOW()), but could just as easily use a Named Formula: =SUM(OFFSET(Totals2009,0,0,ThisMonth,1)) Here’s the formula in Name Manager: How it works OFFSET’s... Continue →