How to display the first and last dates in series of dates?

S

superock

Hi all,

I would like to display the first date (Earliest in seperate cell) an
the last date (Latest in seperate cell) of a column of dates, thes
dates in the column would be in a random order and should not just b
sorted (wich would obviously solve the problem)

I thought DATEDIFF may help but am not sure, thanks for any help.

Superoc
 
N

Norman Harker

Hi Superock!

Since dates are serial numbers from 31-Dec-1899, you can use MIN to
get the earliest date and MAX to get the latest.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First, Last occurance of date in column 7
Scaling multiple columns 0
Problem using IF statement with dates as part of the formula 4
Merging from an Excel file with graphics 1
Problem with formula for finding last greater than/less than or equal to value 2
using two cells 1 with total time n 1 with date how can i put the. 2
Row reference for consecutive series calculation 0
Find last date of sold stock and sold price. 2

Top