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

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -