Forum Discussion

Robgmcp's avatar
Robgmcp
Copper Contributor
Apr 03, 2024

Excel formula using dates

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)

Excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Apr 03, 2024
    Use FILTER() function. Please attach a sample file.
    • Robgmcp's avatar
      Robgmcp
      Copper Contributor
      Apr 07, 2024

      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

Resources