Midyear Roundup: My Best Dates

Some of my fave Excel Date Functions. Some old, some new; all designed to help track the passage of time.

Date Functions:

EOMONTH
returns the last day of the month
EOMONTH ( start_date , month )
EDATE
returns the date x number of months before/after a given date
 EDATE ( start_date , months )
NETWORKDAYS
calculates the number of working days
(see also NETWORKDAYS.INTL)
 NETWORKDAYS ( start_date , end_date , [holidays] )
TODAY
returns the current date
 TODAY( )
WEEKNUM
returns serial number for a given week
 WEEKNUM ( date , [week_start] )
WORKDAY
calculates the next valid work day
(see also WORKDAY.INTL)
WORKDAY( start_date, days, [holidays] )

 

YEARFRAC
returns the date as a fraction of the year
 YEARFRAC ( start_date , end_date , [basis])

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

SOS: Save Our Swiss Alps (with Snowblowers?)

Starting this summer, Johannes Oerlemans of Utrecht University and his colleagues will blow artificial snow onto a small glacier at the foot of Diavolezzafirn, in the south-eastern part of Switzerland. The hope is that a thin white sheet of snow will increase the sunlight reflected, and thus protect the ice underneath from melting, Oerlemans explained at the European Geosciences Union on Thursday (Apr. 27). If this $100,000 pilot project is successful, researchers hope they can raise funding to use the technique to protect the Morteratsch glacier, a huge tourist attraction that’s considered a national treasure—but is shrinking.

via Switzerland will blow artificial snow onto its prized glaciers in an attempt to save them — Quartz

Swiss Expands Surveillance Powers on Data


First it was your bank account, now it’s your data.

In the wake of the 2014 Snowden revelations about mass surveillance programs, startups with concerns about overreaching government requests for user data settled on Switzerland as a base for their business, drawn to its perceived favorable privacy laws.

They may need to look elsewhere.

Sunday, Swiss citizens approved granting the government the power to lawfully hack into computers, install malware, tap communications (i.e. phone, and internet) and to install hidden cameras in private locations in order to gather data. Said ‘hacking’ to be done in the name of National Security and to be exercised with restraint.

Fore more read TechCrunch article: Swiss public back law expanding surveillance powers

Minatur Hamburg via Google Streets

Take a mini desktop vacation!

Visit the worlds largest miniature railroad set,  Miniatur Wunderland, courtesy of Google Straße

swissmini

Click and drag within the interactive frame, below, to explore 360 view street scene from Switzerland
or click this link to fully explore other miniature locales including Austria, America, & Germany.

Swiss Scientists Program Robots To Build Bridges Autonomously

AutonomosDrones -ETH

University researchers at the Swiss Federal Institute of Technology (ETH) in Zürich have designed drones that work together to build a rope bridge. Watch this cool video to see them in action.

For more, follow this link to original QZ.com article:

Swiss Health Insurer Tests Fitness Trackers That Penalize Inactive People

CSS, one of the country’s biggest health insurers, launched a pilot project in July, in which the company tracks the movements of 2,000 volunteers on a daily basis using digital pedometers. The program is intended to aid insurance companies in tailoring their offers to their customers’ needs.

For more click here to view the original article on Quartz.com