Search results 61

Sorted from new to old.

DateOffset_FromMMDD

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

Thu 8AM

ANStrColor2RGBA_Para

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

2025Dec20

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

2025Jun12

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1

Quarter1stLastDate_FromQuarterText

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

2024Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

Q_NoOfdays

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

2024Jun9

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

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

HTML2Str

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

2023Nov5

BusinessDateDiff

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

2023Oct25

NumberFoundinsideTag

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

2023Aug21

1 2 3 4