View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Annie Annie is offline
external usenet poster
 
Posts: 103
Default Calculate Revenue based on dates within a month

Hi,

I need help calculating the revenue for the month of August. The date fomat
is mm/dd/yy. I have many rows of data. The projecte dates are in Column L
and the Factored MRR Revenue is in Column AO. The projected dates are from
Jan - Dec. I only need to extract the revenue for the dates in August.

Can someone please help me. I've tried using the Sumif formula but I can't
figure out how to write the formula to extract dates in August.
--
Thanks, Annie