Where would YOU look for ....
 

Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start date
and an end date.


--
Biff
Microsoft Excel MVP

Where would YOU look for ....
 

Well I suppose I would start with Dates.
As it turned out, my own code file under "Dates" contained
this formula from Myrna Larson...

"Determines the number of occurrences of a particular day, falling between two dates."
A2 = latest date, A1=first date, B1 is number of the day to find (Sunday = 1).
'=INT((A2-A1)/7)+IF(WEEKDAY(A1-B1)+MOD(A2-A1,7)=7,1)

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"T. Valko"
wrote in message
Suppose you have a reference book in front of you.
You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:
Counting and Summing Techniques
Working With Dates and Times
Which chapter would *you* look in for counting Thursdays within a start date
and an end date.
--
Biff
Microsoft Excel MVP

Where would YOU look for ....
 

On Feb 22, 7:37 pm, "T. Valko" wrote:
Suppose you have a reference book in front of you.
[....]
Which chapter would *you* look in for counting Thursdays
within a start date and an end date.

None of the above -- well, below ;-).

The __index__ is where you go to find things in a reference book.
A __good__ reference book would have an index entry for "counting",
with subentries for, perhaps, "days of the week". That is, if there
is
any discussion or examples related to that topic in the text.


----- original posting -----

On Feb 22, 7:37*pm, "T. Valko" wrote:
Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start date
and an end date.

--
Biff
Microsoft Excel MVP

Where would YOU look for ....
 

Fri, 22 Feb 2008 22:37:30 -0500 from T. Valko
:
Suppose you have a reference book in front of you. You want to see
if there is anything related to counting the number of Thursdays
within a start date and an end date.

The table of contents lists chapters for:
Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a
start date and an end date.

I would look in counting and summing, because I already know that
Excel dates are numbers. But somebody who doesn't know that would
probably look under dates and times.

Want to give us a little more of the background of the question?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

Where would YOU look for ....
 

When you reveal to us the point of this question, will it be entertaining or
educational?<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"T. Valko" wrote in message
...
Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start date
and an end date.


--
Biff
Microsoft Excel MVP

Where would YOU look for ....
 

It could be both depending on your perspective!

If you had a choice between a reference book or an "online library"

Which would you choose?


--
Biff
Microsoft Excel MVP


"RagDyeR" wrote in message
...
When you reveal to us the point of this question, will it be entertaining
or
educational?<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"T. Valko" wrote in message
...
Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start
date
and an end date.


--
Biff
Microsoft Excel MVP

Where would YOU look for ....
 

Being in excess of 69 years on this earth, I tend to gravitate to the
established references of the printed word.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"T. Valko" wrote in message
...
It could be both depending on your perspective!

If you had a choice between a reference book or an "online library"

Which would you choose?


--
Biff
Microsoft Excel MVP


"RagDyeR" wrote in message
...
When you reveal to us the point of this question, will it be entertaining
or
educational?<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"T. Valko" wrote in message
...
Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start
date
and an end date.


--
Biff
Microsoft Excel MVP

Where would YOU look for ....
 

I'd look in "counting and summing" first and I'm greedy.

I'd want the hardcopy of the book to thumb through when I'm not in front of a
pc. But I'd rather have a PDF version instead of online. For the most part, I
find web based stuff slow and difficult to traverse.



"T. Valko" wrote:

It could be both depending on your perspective!

If you had a choice between a reference book or an "online library"

Which would you choose?

--
Biff
Microsoft Excel MVP

"RagDyeR" wrote in message
...
When you reveal to us the point of this question, will it be entertaining
or
educational?<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"T. Valko" wrote in message
...
Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start
date
and an end date.


--
Biff
Microsoft Excel MVP





--

Dave Peterson

Where would YOU look for ....
 

On Fri, 22 Feb 2008 22:37:30 -0500, "T. Valko" wrote:

Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start date
and an end date.

I wouldn't look in the book at all. I'd look in the excel newsgroups, and
tease out this oldie but goodie from Daniel M.

==================
The number of DOW (1= Sunday, 2 = Monday, ..., 7 = Saturday) between a start
date (A1) and an end date (A2) is :

=INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7)

Regards,

Daniel M.
==============================
--ron

Where would YOU look for ....
 

Hey Biff,

Still waiting for that other shoe to drop!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T. Valko" wrote in message
...
Suppose you have a reference book in front of you.

You want to see if there is anything related to counting the number of
Thursdays within a start date and an end date.

The table of contents lists chapters for:

Counting and Summing Techniques
Working With Dates and Times

Which chapter would *you* look in for counting Thursdays within a start
date and an end date.


--
Biff
Microsoft Excel MVP