Search results 60

Sorted from new to old.

SQL Date from DateTime

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

2023Nov29

Timeline css

CSS Timeline, simple, easy, nice piece from bootsnipp From

2023Nov14

BusinessDateDiff

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

2023Oct25

BusinessDateAdd

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

2023Oct11

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

NumberEnding

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

2023May3

ANmaDate

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

2023Apr27

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

DateDiff_En

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

2022Mar3

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

1 2 3 4