I have two problems:First problem is how can I filter my xml calender for entries between two dates when the only cell with the date displays it like:
"When: Sun Oct 27, 2013 7:45pm to 10pm
GMT<br>
<br>Event Status: confirmed"
I can get individual date using an advanced filter on this column using "*Oct*27*" (this will only show entries for the 25th of October) but putting > \ < doesn't work
Second problem is that when I use an =IFCOUNT to count the amount of event, it doesn't take into account the filter so just counts the total amount of this event as opposed to just the filtered ones.
(Sorry, this may be a bit confusing but I'm not to sure how to properly describe my problems)
Any help would be greatly appreciated :D
Bookmarks