For Afghanistan, Egypt, and Pakistan their weekend starts Thursday at sunset, running from Friday through Saturday.
In Malaysia, based upon which part of the country your in, it’s either Saturday thru Sunday, or Friday thru Saturday.
Brunei Darussalam‘s non-contiguous weekend is on Friday and Sunday.
Costa Rica, North Korea and Uganda get only one day, Sunday, as a weekend.
As a follow-up to last week’s post here’s the international solution to calculating workdays.
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
In honor of the 40th anniversary of J.K. Rowling’s seminal classic, Harry Potter, this post magically exposes a hidden excel function!
Ever wonder if your spreadsheet is keeping something from you?
DATEDIF is an under-documented function. It allows you to calculate the difference between two dates. Although it doesn’t appear in the Function Wizard (it exists to insure backward compatibility with Lotus and earlier Excel versions) it is a powerhouse when it comes to calculating date differences.
Using DATEDIF function:
Format: =DATEDIF ( date1, date2, “interval”)
date1must be the earlier of the two dates or an #NUM error is returned.
Ever wonder what your birthday looks like expressed in roman numerals? Want to display your travel expenses using Thai?
Use these functions to convert numbers to their respective lingo.
Converts number to Thai text
สี่ร้อยห้าสิบเอ็ดบาทถ้วน (Four Hundred and Fifty-one)
Convert Roman Numeral to Arabic
Convert Number to Roman Numeral
=ROMAN(1984 ,  )*
*ROMAN, has an optional argument, format . When format is included, the number is expressed differently, ranging from classic (0) to simplest (4). When this argument is omitted, the classical format is displayed.
Reformatting a list of names is challenging when some of the names have middle names and others do not. Using Word’s Advanced Replace dialog and wildcards makes it easy to rewrite a list in Lastname, First M. format.
3 minute e-Learning demo:
To Reformat a List of Names to Last, First M.
Select your list of names.
Press CTRL+H. The REPLACE dialog appears.
If necessary click More button to display full dialog.
Check Use Wildcards.
In the Find what field type: (*) ([! ]@)^13 Important:observe spaces.
In the Replace with field type:\2, \1^p Important:note thespace after the comma.
Click Replace All. When prompted to “..continue searching the remainder of the document” click No.
Close the dialog.
Why it works
The find pattern looks for two groups: first name with optional middle name or initial and last name.
(*)_ finds expression1, first and middles names
([!_]@)^13 finds expression2, the remainder of name up to and including hard return (ascii char 13)
These names can now be referred to as expressions \1 and \2. In our replace statement we transpose them, separate them with a comma and space, and end with a hard return (^p).
Note: _ is used above to illustrate use of space.
Codes that work with Find and Replace
Paragraph mark ( )
^p (doesn’t work in the Find what box when the Use wildcards option is turned on), or ^13
One or more occurrences of the previous character or expression
@ ex: lo@t finds lot and loot.
Any single character except the characters in the range inside the brackets
[!_] ex: t[!a-g]ck finds tock and tuck, but not tack or tick.