The Student Room Group

Help please - Excel Programming

Not sure if this is the right forum, but I'll post it anyways. What I need help with is 2 things.

The first is that I'm trying to find the duration between two dates in excel. I.e., if I put in today's date and want the end date to be 6/20/09, then it would tell me the number of days between the two dates. Is this possible somehow?

The second thing is more complicated. I have 7 columns and over 100 rows and each cell (in this area) has 1 number in it. What I want to find is the mode, the most frequent number, OUT OF ALL THE CELLS, not just per column or per row. Is this possible?

Latest

Trending

Trending