Thursday and Friday End The Week
I needed to determine the number of weekdays between two dates for some project planning in which I found myself. Initially, I pulled out a calendar and counted, but thought "hey, technology" and opened up Microsoft Excel.
The version of Excel I have available doesn't have a built-in "Formula to Find Number of Weekdays Between Dates" so I went off to Google and poked around, eventually winding up on the page to which the quoted item links. Quoting from that page, I find:
In all versions of Microsoft Excel including version 4.0 the following formula can be used to find the number of weekdays between two dates,where Thursday and Friday are the weekend (emphasis mine)
What? That's helpful? Wow. The complexity of the formula is about what I expected:
=A2-A1+1-INT((A2-A1)/7)*2-IF(AND(WEEKDAY(A2)<>7,WEEKDAY(A1)<>7,
WEEKDAY(A2)<WEEKDAY(A1),WEEKDAY(A1)<>6),2,IF(AND(WEEKDAY(A2)=7,
WEEKDAY(A1)<=5),2,IF(AND(WEEKDAY(A2)=6,WEEKDAY(A1)<=5),2,
IF(OR(WEEKDAY(A1)=6,WEEKDAY(A2)=5),1,IF(AND(WEEKDAY(A1)=7,
WEEKDAY(A2)=6),2,0)))))-IF(AND(WEEKDAY(A1)=6,WEEKDAY(A2)=5),1,0)
And I'm pretty sure that it uses Saturday and Sunday as the weekends, but I haven't verified.
As it turns out, the page strongly suggests using the "NETWORKDAYS" add-in function, which I did and it worked well.
Posted at 08:29AM Apr 25, 2009 by schnee in General |
Every Cow Has Its Egret
I got my ring back. The combination of a metal detector, little rain and an archeologist turned out to be a winning one. Mike (the archeologist) and I located the ring with 10 minutes of us arriving on the site.
After the find, we were trying to figure out what to do. We didn't ponder the question too long - we were thirsty and decided to go have a beer. We hopped into the Outback and headed down Country Road 390, back towards Austin. Not too far from the ring site, we passed a score of black cows, rummaging in a green field speckled with yellow flowers.. Next to every cow - every single cow - was a small white bird(*). I absent-mindedly said "Hmmm, every cow has its egret". Mike looked at me, I looked at him and in the middle of poor rendition of a Poison tune, turned the Subaru around, parked it, and snapped a few photographs.
Observationally, "every cow has its egret" is pretty obvious. Yep, there's a cow and yep, there's an egret. Philosophically, metaphysically, what does it mean? "Every cow has its egret".
Heavy.
(*)It was a small white bird. No orinthologist I, I declared it to be an egret. Right or wrong, in the big picture, it doesn't matter.
Posted at 02:40PM Apr 04, 2009 by schnee in General | Comments[1]
40 Yard Line
I traveled back to Austin yesterday. Standing in the boarding line, I over heard a teen-aged girl traveling alone chatting with a married couple, who apparently had older children. The mom's first questions to the girl: "You go to highschool? What division is it? You know, football, 'A', 'double A'?". The first set of questions. About the football program.
The girl let out that she is a member of the drill team. The mom apparently had two daughters on a team, so those questions then flew. The first one: "What yard line are you on?". Drill team yard-lineage is a sort of status symbol. Who knew?
Posted at 09:51AM Jun 25, 2007 by schnee in General |
Banana Jump
This was just one of those "WTF" moments. Only in Austin? Jeez, I hope so. Stopped at a red light, on a bridge, over Barton Creek, on Barton Springs road, I looked around. I had a beautiful view downstream to the hike-and-bike trail's footbridge over the creek. The clear water floated several canoes and kayaks and lots of joggers crossed the bridge.
Except one guy in a yellow shirt. He sat on the railing, legs dangling over. He looked one way, and then the next. Soon, he scootched over a couple of feet and then stood. He let his shirt unfurl and it dangled down to his ankles. A man, standing on a railing, suspended 20 feet over a creek, wearing a body length yellow shirt. And then, he reached behind his head and pulled on the hood. The pointed hood, with a black top. A man, standing on a railing, suspended 20 feet over a creek, wearing a body-length banana costume. No sooner than I thought "what the...?", the man jumped.
Then, the light turned green and I drove away.
Posted at 08:36PM May 16, 2007 by schnee in Life |
