Search results 30

Sorted from new to old.

Calculation_StaleValues

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

Jun30

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

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

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

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

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

1 2