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.