Let's see if we understand you.....
Columns G, H and I, may or may not contain the letter
abbreviations for the
days of the week.
>G3 H3 I3 N3 O3 Q3
>M F (blank) 10/9/05 12/15/05 (answer)
So, based on your example above, you want to count the Mondays and
between 10/9/2005 and 15/15/2005.
Is that what you want?
Just make sure that
the abbreviations you use match what are in this formua:
"girlfriend in school" <email@example.com> wrote
in message news:226F2179-C5DF-4133-B379-DE3653DF6D74@microsoft.com...
> This is great, but it doesn't factor the variability of the days tried to
> explain in my initial query. Data in columns G, H, and I will be days of
> week, but will change from row to row (as will the respective dates in
> columns N and O). Sometimes there will be no data in H and/or I. I am
> hoping to create something where a clerk can put in the days of the week
> the spreadsheet formula will count up the days. Note: the number of days
> will then be used in another formula to calculated $$.
> Perhaps if I show you what I have so far will help:
> G3 H3 I3 N3 O3 Q3
> M F (blank) 10/9/05 12/15/05 (answer)
> I tried Bernie's formula but that didn't work. I had to change cell
> references, and I don't understand the formula (and cannot decipher Excel
> Help's explanation) so that might be why.
> I am currently using IF formulae to reference columns G, H and I into the
> weekday_number, but think I have exceeded the quantity of formulae one can
> put in a single cell.
> If you have an answer, WHAT A RELIEF!!!
> "Biff" wrote:
>> After seeing Bernie's post I'm wondering if I understand the question!
>> To count specific weekdays between 2 dates (inclusive):
>> Where Monday = weekday 1 and Sunday = weekday 7
>> Start date in A1
>> End date in B1
>> To count more than 1 weekday like Mondays and Tuesdays:
>> "girlfriend in school" <firstname.lastname@example.org>
>> in message news:C5271A39-23D4-46D5-B3B4-72BD40B4F9E2@microsoft.com...
>> >I need to count the number of days between a start date and end date and
>> > questions about this I found here don't seem to help (boggle me!) I
>> > need
>> > a
>> > universal formula that will cover variable days which are listed in a
>> > separate column:
>> > G (rows) = names of days; J (rows) = start date; K (rows) = end date.
>> > On
>> > top of this, I am sometimes having to count more than one day (up to
>> > three)
>> > within a week (e.g., Mondays AND Fridays) which I'd be willing to put
>> > in
>> > separate columns (i.e., columns G,H,I) if needed, but if only one
>> > column
>> > has
>> > a day listed, the formula needs to ignore the empty columns.
>> > A knotty problem?