The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,766 other followers

Archive for September 30th, 2019

Chronological Facebook

Posted by jpluimers on 2019/09/30

For people still using Facebook: visit it using www.facebook.com/?sk=h_chr.

This will open the chronological view of your Facebook feed.

Via:

–jeroen

 

Posted in Facebook, Power User, SocialMedia | Leave a Comment »

Readable weekdays in Excel

Posted by jpluimers on 2019/09/30

Since I always forget this: [WayBackExceljet: Get day name from date

If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs.

Basically there are four ways go get the day of the week; the first three are readable, but when ordered, they are ordered alphabetically. The last one is numeric.

Combining the numeric with the text is easier in for instance Pivot Legend Fields (Series).

So here they go (based on the above link), assuming that B4 contains a timestamp:

  1. =WEEKDAY(B4) gives you the numeric weekday (starting with Sunday=1 to Saturday=7) which allows sorting in a meaningful order
  2. =TEXT(B4,"dddd") gives you the full day name of B4 in your locale
  3. =TEXT(B4,"ddd") gives you the shortened day name of B4 in your locale
  4. =CHOOSE(WEEKDAY(B4),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") gives you a name of your liking from a series of 7 texts

Note that depending on your locale, these formulas might actually need a semicolon:

  1. =WEEKDAY(B4)
  2. =TEXT(B4;"dddd")
  3. =TEXT(B4;"ddd")
  4. =CHOOSE(WEEKDAY(B4);"Sun";"Mon";"Tue";"Wed";"Thu";"Fri";"Sat")

–jeroen

Read the rest of this entry »

Posted in Excel, Office, Power User | Leave a Comment »

Meeting Agreements for High Performing Teams – Noteworthy — The Journal Blog

Posted by jpluimers on 2019/09/30

Worthy short read: [WayBackMeeting Agreements for High Performing Teams – Noteworthy — The Journal Blog

A quote from it:

[WayBackPatrick Lencioni‏ @patricklencioni: If someone offered me a single piece of evidence to assess the health of an org, I would want to observe the executive team during a meeting

–jeroen

via: [WayBack] Meeting Agreements for High Performing Teams – Noteworthy — The Journal Blog – Marjan Venema – Google+

Read the rest of this entry »

Posted in Agile, Development, LifeHacker, Power User, Software Development | Leave a Comment »

 
%d bloggers like this: