Hi,
I'm trying to count the number of records for a month (from 1st of month to end of month) using the COUNTIFS function:
=COUNTIFS(TradeLog[Trade Date],">="&C1,TradeLog[Trade Date],"<="&EOMONTH(C3,0))
The dates in the reference range are derived from Vlookup formula and formatted as 'dd-mm-yyyy'. But this is not working for me and always returning 0.
I have highlighted the field where this formula is used in the 'Monthly Summary' field in yellow.
When i use the COUNTIF function for non-date numeric criteria, it is working fine, but then again i need to combine it with the date criteria ultimately.
I'll be obliged if anyone can help me spot the cause of this so this can be fixed.
Thanks & Regards,
Shriram
Bookmarks