View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Twishlist Twishlist is offline
external usenet poster
 
Posts: 54
Default convert higlighted days inexcel calendar to value, then sum

I have an excel calendar on which I have highlighted particular dates. I
would like a formula that looks at the range and counts the cells that are
highlighted yellow, then multiplies that number by a x hours.
Is that easy to achieve?