SQL Date from DateTime

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

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

GEWin.zip

HTML2Str

Sppecial version to convert HTML to string. Uses RemoveHTML, then after that ...

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

BusinessDateAdd

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

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...