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.
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.
Excel is great at splitting text across multiple columns. For basic text separation (e.g. putting first and last name in separate columns) the LEFT and RIGHT functions work fine. But these functions fall short when applied to data that follow an inconsistent pattern. In the below example, the errant inclusion of a middle name wrecks havoc with our formula results.
Using the SUBSTITUTE function one can identify and replace the last space in the cell with a uniquely identifying character (e.g., an underscore). This character can then be used as a delimiter to separate Lastname from full name.
SUBSTITUTE: replace character(s) within a cell with specified character(s)
= SUBSTITUTE ( text, old text, new text, instance)
Note, instance is optional; when omitted, every occurrence of old text is replaced with the new.
Linking the worksheet name to a cell in the spreadsheet is easily accomplished using Excel’s CELL function. Once joined by the MID and SEARCH functions, you need only change the sheet’s name and the linked cell will update to match.
Displaying the Sheet Name in a Cell
Type (or copy and paste) the following formula into a cell