Hello and good morning everyone,

I have been asked if it is possible to create a formula which will take
dates from various worksheets in a workbook and place the oldest on another
worksheet. e.g. sheet 1, sheet 2, sheet 3, sheet 4, will all have a date in
a particular cell (A1) and I have to place the oldest date in sheet 5.

Now I know that Excel calculates dates as a number starting 1 Jan 1900,
therefore, I would have thought it might be possible. But have not been
able to find help on this exact subject. Do you know if the software has
this function? I was thinking that maybe I could use MIN in combination
with an IF-Statement, but not exactly sure how to do this?

Kind regards

Ricky