Search results 45

Card image cap
Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last last day in a Quarter Mar 31st, Jun 30th, ...

Card image cap
DateDiff_Networkdays

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

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image cap
OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

Card image cap
FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Card image cap
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Card image cap
HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Card image cap
Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Card image cap
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Card image cap
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.