Forum Discussion
Solved
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)
- Use FILTER() function. Please attach a sample file.
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