We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Find Max Date in workbook

I have a workbook with various dates (dd/mm/yyyy) in Column A. I would like to get the Max date.
something like :
IRange maxdate = worksheet.FindFirst(date ==> maxdate)

I do not have a column name for Dates.


1 Reply

MM Manikandan M Syncfusion Team April 4, 2013 07:41 AM UTC

Hi Adrian,

Thanks for using Syncfusion products.

Currently we don't provide the support for finding the max date value in XlsIO. Whereas we could get the max date using Excel function 'MAX'. We have attached the simplified sample to get the max date in the below. Please make use of this and let us know if this helps you.

We have provided the code snippet for the same below.

Code snippet:
            IRange maxDate = sheet["B1"];
            maxDate.NumberFormat = "MM/dd/yyyy";
            maxDate.Formula = "MAX(" + sheet.Columns[0].AddressLocal + ")";

If you need any assistance, please create the new incident with your query.

Manikandan M.


Live Chat Icon For mobile
Up arrow icon