Forum Discussion
Formula to get latest date among dates
Hi, Here i've attached my which has GRN details. 1st tab has GRN date wise qty details and second tab has closing stock details. i need to get latest GRN date and qty to second tab (Closing Stock). ...
its nice. but when click on cell its going wrong. how should enter this maxifs formula
Which version of Excel do you have?
MAXIFS function works only in Excel 2019 or Office 365, if you haven't one of them, you will get the #NAME error!
If you have an earlier version of Excel, please try this alternative formula:
=AGGREGATE(14,6,(A2='GRN Details'!$A$2:$A$1505)*'GRN Details'!$B$2:$B$1505,1)
Hope that helps