Date difference - unexpected answer

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,922
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have the following set up, searching for MIN and MAX dates per entity, but 2 months difference for :CAC 40 between 30/11/2007 and 28/02/2008 is wrong(?):

Workfile KS v3.1.xlsm
NOPQ
1**** Select Account ****Min DateMax DateMonth Count
2:CAC 4030/11/200728/02/20082
31060 CAPITAL28/02/201531/07/20155
436ONE HEDGE USD31/08/201431/12/201628
536ONE OFFSHORE31/01/201031/08/201455
6432 PARK AVENUE - PE30/06/201231/05/201647
7AAAP30/09/201731/10/20171
Transactions
Cell Formulas
RangeFormula
N2:N1000N2=SORT(UNIQUE(tbl_Transactions[Account]))
Q2:Q7Q2=DATEDIF(O2,P2,"m")
O3:O7O3=MINIFS(tbl_Transactions[EoM Date],tbl_Transactions[Account],$N3)
P3:P7P3=MAXIFS(tbl_Transactions[EoM Date],tbl_Transactions[Account],$N3)
Dynamic array formulas.

Can explanations why or suggestions to correct?

TIA,
Jack
 
Last edited:

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,224,074
Messages
6,176,228
Members
452,715
Latest member
DebbieCox

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top