I need a formula or code that will count the "number of days" from a column of dates, for example Column A and B has the following:
Column A
8/12/2013 AGRAHAM
8/12/2013 AGRAHAM
8/12/2013 AGRAHAM
8/13/2013 AGRAHAM
8/13/2013 AGRAHAM
8/13/2013 AGRAHAM
8/13/2013 AGRAHAM
8/14/2013 AGRAHAM
8/14/2013 AGRAHAM
8/14/2013 AGRAHAM
8/15/2013 AGRAHAM
8/16/2013 AGRAHAM
8/16/2013 AGRAHAM
8/16/2013 AGRAHAM
8/16/2013 AGRAHAM
I need a formula that will populate one cell that there are "5" days listed in column A.
Bonus question: this list above moves on to another name with another date range as I go down the spreadsheet. If the formula or code could be dragged down (calulating those dates into a "number of days", that would be great!
Bookmarks