Excel formula using dates

[Robgmcp]

how do I use Sumif to compare dates in format dd/mm/yyyy (column H) to extract current financial year (01/07/2023-30/06/2024) total amounts (column E)

[#2 · Accepted solution]

Use FILTER() function. Please attach a sample file.

[#3]

@Harun24HR thanks for your response.  What I am trying to do is sim the $ column for the current financial year (01/07/2023 to 30/06/2024).  When I try this using Sumif and the date column i get the #VALUE response.  I have tried re formatting the column as text and date and also tried using date functions in the formula.

Hope you can help.  See example

Thanks Robgmcp

[#4]

@Robgmcp It seems problem with system date formatting. Try SUMIFS() like-

=SUMIFS(A:A,D:D,">="&H1,D:D,"<="&H2)

[#5]

Thanks, I can see that works but I'll need to change all my dates to US format.