Search results 43

Sorted from new to old.

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

1 2 3