MIN date from multiple different worksheets in a workbook

R

ricky

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
 
G

Guest

Put this on sheet 5 and format the cell as date and it will return the
earliest date from A1 on sheets 1,2,3 &4.

=MIN(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1)
 
R

ricky

Thanks Mike, just worked it out too....


Mike said:
Put this on sheet 5 and format the cell as date and it will return the
earliest date from A1 on sheets 1,2,3 &4.

=MIN(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1)
Click to expand...
 

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

Excel Workbook with Multiple worksheets 2
Relative worksheet reference for multiple worksheets in a workbook 5
dynamic data copying between worksheets 0
Please help - Linking worksheets 5
Changing dates across multiple worksheets 5
Lookup MIN Date 6
combining data from multiple worksheets into one 6
Help with time function 4

Top