Search results 206

  2. Search results
  3. dat
Card image cap
BusinessDateDiff

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

2023Oct25
Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image cap
BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11
Card image cap
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3
Card image cap
Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1
Card image cap
Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8
Card image cap
Times_inHours

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

2023Jul20
Card image cap
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19
Card image cap
DB connection driver

What is the Driver part in ConnectionString

2023Jun2
Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23
Card image cap
NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3
Card image cap
ANmaDate

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

2023Apr27