Where would YOU look for ....

[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.

 

[Jim Cone]

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.

 

[joeu2004]

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 -----

 

[Stan Brown]

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?

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

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.

 

[T. Valko]

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?

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

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?

 

[Dave Peterson]

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.

 

[ilia]

I would look under weekdays, then under counting, and combine the two.

But of course, I already know how to do it so it's difficult to put
myself in the shoes of someone who doesn't.

As far as type of reference, I liked things in print, but I appreciate
the ability of finding the appropriate section of a PDF before I print
it.

 

[Ron Rosenfeld]

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

 

[RagDyer]

Hey Biff,

Still waiting for that other shoe to drop!<bg>