How can I get this formula to work. The idea is to create a dynamic formula
where the it sums a range based on the date as it changes each month. e.g.

=SUMIF(Dates,"<=Currentmonthend",revenue)
=SUMIFS(revenue,Dates,"<=Currentmonthend")

neither works, it will work if I substituted a proper date such as
03/31/2009 for currentmonthend, whenever greater than or less than sign is
involved it does not work. Any ideas? Thanks.

Henry