Search results 63

Sorted from new to old.

DateOffset_FromMMDD

Calculate the new MMDD from a date formated as MMDD after adding/subtracting ...

Apr9

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

2025Mar24

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

Quarter1stLastDate_FromQuarterText

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

2024Jul26

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

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

2024Feb15

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SQL Date from DateTime

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

2023Nov29

UserChanged_Log4

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

2023Nov28

1 2 3 4