Search results 50

Sorted from new to old.

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

Nov7

Quarter1stLastDate_FromQuarterText

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

Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

Jul26

Q_NoOfdays

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

Jun9

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

SQL Date from DateTime

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

2023Nov29

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

BusinessDateDiff

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

2023Oct25

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

1 2 3 4