View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maurolava Maurolava is offline
external usenet poster
 
Posts: 4
Default Looking for a formula

I need help with a formula that will find an specific cell when it meet
specific criteria.

A B C
1 Monday 11/10/2008 1
2 Tuesday 11/11/2008 0
3 Wedy 11/12/2008 1
4 Thursday 11/13/2008 1
5 Friday 11/14/2008 3
6 Saturday 11/15/2008 2
7
8 Monday 11/17/2008 2
9 Tuesday 11/18/2008 2
10 Wedy 11/19/2008 1
11 Thursday 11/20/2008 2
12 Friday 11/21/2008 3
13 Saturday 11/22/2008 1
..
..
..

I want a formula that can find the number on column C after each Monday on a
different sheet. Another for Tuesday, Wednesday and so on.

Is that possible?

Thank you in advance,

Maurolava