Search results 57

Sorted from new to old.

BusinessDateDiff

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

2023Oct25

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

ANmaDate

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

2023Apr27

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Bootstra/386

A bootstrap v2, v3 or v4 theme to make webpages look like they are from the ...

2021Jan6

ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

2020Dec24

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

1 2 3 4