MIN date from multiple different worksheets in a workbook
 

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

MIN date from multiple different worksheets in a workbook
 

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)

"ricky" wrote:

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

MIN date from multiple different worksheets in a workbook
 

don't worry got it!!!


"ricky" wrote in message
...
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

MIN date from multiple different worksheets in a workbook
 

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


"ricky" wrote in message
...
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

MIN date from multiple different worksheets in a workbook
 

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


"Mike" wrote in message
...
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)

"ricky" wrote:

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