Search results 116

Sorted from new to old.

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

SSL/TLS certificate add/update

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

2024Nov7

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

2024Sep6

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

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

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

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

OneDrive Reset

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

2024Mar5

DateDateDate

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

2024Mar3

1 2 ...7 8