Skip to content

Instantly share code, notes, and snippets.

View Mohammedkb's full-sized avatar

Mohammed Barakat Mohammedkb

View GitHub Profile
@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
CountWeekday = LAMBDA(StartDate, EndDate, WeekdayNumber,
LET(
DateRange, ROW(INDIRECT(StartDate & ":" & EndDate)), WeekdayRange, WEEKDAY(DateRange), WeekdayFound, N(WeekdayRange=WeekdayNumber), CountWeekday, SUM(WeekdayFound), CountWeekday
)
);
@Mohammedkb
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.
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),