a couple of laughzillas on a blue diamond background

Centennial Weekend Birthdays

Aug04
by on August 4, 2014 at 11:30 am
Posted In: Around the Web, Date Functions

On this episode of the BBC’s More or Less podcast, they discussed big, round birthdays that fall on a weekend. A listener said that she had to wait until her 60th birthday for it to fall on a weekend. The guy who figured out how unlucky she was tested every birthday from January 1, 1900. Since he picked that date, I assume he used Excel, but he never said.

They did include the caveat “as an adult” so that leaves off the 10th birthday. Here’s how I did the math.

I started with 1/1/1900 is cell A2 and used the formula

=A2+1

copied down to today. Then in B1:J1, I entered the values 20-100. The formula in B2 is

=WEEKDAY(DATE(YEAR($A2)+B$1,MONTH($A2),DAY($A2)),2)>=6

I added the value in row 1 to the year to make the centennial birthday and fed that into the WEEKDAY function. WEEKDAY returns 1 through 7 representing the day of the week. I used ‘2’ for the second argument so that Monday is 1 and Saturday is 6. Then I return TRUE or FALSE depending on whether the weekday is greater than or equal to 6.

Column K finds the minimum age that has a TRUE under it

=MIN(IF(B2:J2,$B$1:$J$1,""))

That’s an array formula, so I entered it with Ctrl+Shift+Enter.

Next, I repeated 20-100 in column N. These formulas complete the table

    O3        =COUNTIF($K$2:$K$41832,N3)
    P3        =O3/SUM($O$3:$O$11)
    Q3        =Q2+P3

As if that wasn’t enough, I wanted to make a single formula that could accept a date and return the earliest major birthday that was on a weekend.

=MIN(IF(WEEKDAY(DATE(YEAR(O16)+{20,30,40,50,60},MONTH(O16),DAY(O16)),2)<6,"",{20,30,40,50,60}))

That’s also an array formula, so you know what to do. I celebrated my 30th birthday on a weekend.

└ Tags: 
a couple of laughzillas on a blue diamond background

Rakuten believes its chat app Viber can ‘completely change’ its e-commerce business

Aug04
by on August 4, 2014 at 11:02 am
Posted In: Around the Web, Mobile, ra

rakuten

Japan’s e-commerce giant Rakuten surprised many when it stumped up $900 million to buy mobile messaging and calling service Viber in February. The deal was announced just five days before Facebook’s landmark $19 billion acquisition of fellow chat app WhatsApp — while WhatsApp is the industry leader by some margin with over half a billion active users each month, Viber is performing better than might have been expected. According to Rakuten’s latest earnings report — which was released today and first spotted by Tech In Asia — the business now has 400 million registered users. That’s up from 280 million registered…

This story continues at The Next Web

The post Rakuten believes its chat app Viber can ‘completely change’ its e-commerce business appeared first on The Next Web.

└ Tags: 
a couple of laughzillas on a blue diamond background

Offline over the weekend? Read all the tech news you missed right here

Aug04
by on August 4, 2014 at 10:54 am
Posted In: Around the Web, Insider, Roundups

coffee_Night

Sometimes missing out on the latest tech news and features over the weekend can’t be helped: you had dull life chores to take care of, you promised to take the kids to that amusement park, you really needed to get the garden under control, your hangover prevented you from functioning properly. There are many reasons why you might not have been able to keep up with the latest-and-greatest happenings from tech land in the last 48 hours. It’s ok, we’re not here to judge your excuses. We’re here to pay attention so you don’t have to. So, put aside those promises…

This story continues at The Next Web

The post Offline over the weekend? Read all the tech news you missed right here appeared first on The Next Web.

└ Tags: ,
a couple of laughzillas on a blue diamond background

You can now use your EE phone instead of an Oyster card for contactless payments on London buses

Aug04
by on August 4, 2014 at 9:53 am
Posted In: Around the Web, Insider, Product Updates, UK

London_Bus

EE’s phone customers can now pay for travel on London buses simply by tapping their phone on the bus’s Oyster card reader. In order to use your phone to pay for your journey, you’ll need to be a user of EE’s Cash on Tap app, which itself requires a compatible handset. Currently, newer devices like the HTC One M8 and LG G3 are not supported, but the company says it will be compatible with over 500,000 customers’ handsets by the end of the year. Thankfully, the daily and weekly maximum payment caps applicable to Oyster card travel are still in place…

This story continues at The Next Web

The post You can now use your EE phone instead of an Oyster card for contactless payments on London buses appeared first on The Next Web.

└ Tags: ,
a couple of laughzillas on a blue diamond background

Kogan’s £150 4G Agora Android smartphone comes to the UK

Aug04
by on August 4, 2014 at 9:09 am
Posted In: Around the Web, Gadgets, Insider, UK

KoganAgora4G_feat2

Australian electronics manufacturer Kogan has teamed up with Benq to launch a 4G version of its 5-inch Kogan Agora smartphone in the UK. First announced for Australia last week, the device runs the KitKat (4.4.2) version of Android, has a 1.2GHz quad-core processor and offers an 8-megapixel rear-facing camera. On the front, there’s a 1.3-megapixel snapper for video calling and the seemingly obligatory selfies. Essentially, it’s very similar to the Kogan Agora launched in September last year, but with the addition of 4G LTE capabilities.  While the internal memory is limited to just 8GB, there’s an expansion slot which will…

This story continues at The Next Web

The post Kogan’s £150 4G Agora Android smartphone comes to the UK appeared first on The Next Web.

└ Tags: ,