LinkBack URL
About LinkBacks
Hi all,
I was wondering if anyone has a formula to find a date range?
For example: I have a series of dates of invoices over a period of a couple of years - what I'd like to do is find the meand median and average date.
Hi all,
I was wondering if anyone has a formula to find a date range?
For example: I have a series of dates of invoices over a period of a couple of years - what I'd like to do is find the meand median and average date.
Last edited by 1Monkey; 08-14-2012 at 11:52 AM.
Simply use
=Average(A1:A1000)
=Median(A1:A1000)
where A1 to A1000 is you list of dates. Note blank cells will be treated as 1/1/1900
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks