How to put the "most recent" date from one sheet into another

[Mighty Magpie]

Hello



I have a worksheet with several sheets named A, B, C, D etc



Column 'I' on Sheet 'A' contains dates which are entered manually in the
format 10/03/2004



In Cell N45 on Sheet 'B' I want to input a formula that will look in column
'I' on sheet 'A' and will pick the most recent date and then show it in cell
N45 (sheet ''B')



This is so I can illustrate that the results are based upon data which has
been entered up to that date



Could someone please advise me how this can be done



TIA



I am using Excel 2002 and Win XP Pro

 

[Andy B]

Hi

Try this:

=MAX("Sheet A"!T:T)
and format the cell as a date

Andy.

 

[Mighty Magpie]

Many thanks - that works brilliantly

cheers

Hi

Try this:

=MAX("Sheet A"!T:T)
and format the cell as a date

Andy.