Thread: Excel formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Excel formula
try sth. like:

=IF(WEEKDAY(A1,2)<7,A1,"")

to count everything except Sundays
Reply With QuoteReply With Quote