Extract the biggest Date

[Mishoshow]

Hi Guys,,

i need a formula to extract the biggest date.

 

[Teeroy]

Use the MAX formula. E.g. if your dates are in A1 to A5
=MAX(A1:A5)

 

[Mishoshow]

Use the MAX formula. E.g. if your dates are in A1 to A5
=MAX(A1:A5)

sorry i forget to mention that the cell A include Amount and the cell B include the date ,, and so on ,, so i need to extract the date and ignore the amount.

 

[Teeroy]

What is the exact format of your data? That will help identify if you need to split off the date data first.
If column B are just dates then change the A to B in the formula, e.g.

=MAX(B1:B1000) assuming you have 1000 or less rows of data.

Don 't forget to format the output cell as a date or you'll just get a large number telling you the date is that many days past 1/1/1900

 

[Mishoshow]

What is the exact format of your data? That will help identify if you need to split off the date data first.
If column B are just dates then change the A to B in the formula, e.g.

=MAX(B1:B1000) assuming you have 1000 or less rows of data.

Don 't forget to format the output cell as a date or you'll just get a large number telling you the date is that many days past 1/1/1900

how to use max formula to get result ??

 

[Peter_SSs]

how to use max formula to get result ??

What is the actual result you would expect from that data?

Better to give us some sample data that we can test with (once we know exactly what "result" you mean. We cannot test with a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[FormR]

Hi, in lieu of your response to Peter, maybe this is what you are looking for.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Sum Amounts	Newest Date		Date 6	Payment 6	Date 5	Payment 5	Date 4	Payment 4	Date 3	Payment 3	Date 2	Payment 2	Date 1	Payment 1
2	52,111,500.00	14/08/2018		14/08/2018	13,500,000.00	25/06/2018	13,500,000.00	15/04/2018	1,000,000.00	12/04/2018	17,648,000.00	12/05/2017	5,000,000.00	14/11/2017	1,463,500.00
Sheet1

Cell Formulas
Range	Formula
A2	A2	=SUMIFS(D2:O2,D1:O1,"Payment*")
B2	B2	=MAXIFS(D2:O2,D1:O1,"Date*")