Mohammed Barakat Mohammedkb
Mohammedkb
/ gist:81dab561999afcf555fbb63af3ddeebd
Created
June 16, 2023 08:05
CountWeekday Function with Excel Advanced Formula Environment (AFE) to count a specific weekday between two dates
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CountWeekday = LAMBDA(StartDate, EndDate, WeekdayNumber, | |
| LET( | |
| DateRange, ROW(INDIRECT(StartDate & ":" & EndDate)), WeekdayRange, WEEKDAY(DateRange), WeekdayFound, N(WeekdayRange=WeekdayNumber), CountWeekday, SUM(WeekdayFound), CountWeekday | |
| ) | |
| ); |
Mohammedkb
/ NumberToWords.txt
Created
March 18, 2022 20:53
Lambda code to be imported in Excel Advanced Formula Environment to build a customized function that converts numbers to words.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| NumberToWords = LAMBDA(DNumValue, CUR, DecimalCUR, DecimalCURPlace, | |
| LET( | |
| NumValue, INT(DNumValue), | |
| Words1,IFS( | |
| len(NumValue)=1,GetDigit(value(NumValue)) & " " & CUR, | |
| len(NumValue)=2,GetTens(value(NumValue))& " " & CUR, | |
| len(NumValue)=3,GetHundreds(value(NumValue))& " " & CUR, | |
| len(NumValue)<=6,GetHundreds(VALUE(left(NumValue,len(NumValue)-3))) & " Thousand " & GetHundreds(value(NumValue))& " " & CUR, | |
| len(NumValue)<=9,GetHundreds(VALUE(left(NumValue,len(NumValue)-6))) & " Million " & GetHundreds(VALUE(left(NumValue,len(NumValue)-3))) & " Thousand " & GetHundreds(value(NumValue))& " " & CUR, | |
| len(NumValue)<=12,GetHundreds(VALUE(left(NumValue,len(NumValue)-9))) & " Billion " & GetHundreds(VALUE(left(NumValue,len(NumValue)-6))) & " Million " & GetHundreds(VALUE(left(NumValue,len(NumValue)-3))) & " Thousand " & GetHundreds(value(NumValue))& " " & CUR), |