| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
| How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
Linear Mode
