What is the purpose of new DAYS() function in Excel 2013? -
i found out excel 2013 has days() worksheet function. appears function same subtracting 1 date another.
one of blogs visited said days() permits work text strings dates, found text strings work subtraction, in:
="7/15/2016"-"7/1/2016"
which results in 14 when enter it, same result as
=days("7/15/2016","7/1/2016")
does know days() date subtraction not?
thanks!
days can more dynamic example create more complex formula dynamic variables =days(vlookup(c3,c5:e16,3,false),b3). in example sent more common them static. using cells can provide similar function assuming in same date , number formats. example using same formula above =vlookup(c3,c5:e16,3,false)-b3.
Comments
Post a Comment