Random codes

Similar codes

MyDayName

Returns the day name in several formats It uses either full date or only ...

2018Apr21

ANmarAmdeen

BusinessDateAdd

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

Oct11

ANmarAmdeen

FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

ANmarAmdeen

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

Jan6

ANmarAmdeen

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

ANmarAmdeen

getDaysInMonth

Gets number of days in a certain month

2018Jul15

DevinGarlit

BusinessDateDiff

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

Oct25

ANmarAmdeen

Times_inHours

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

Jul20

ANmarAmdeen

MyMonthName

Returns the month name in one of 5 formats (below) It can use full date or ...

2018Apr21

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

Aug13

ANmarAmdeen

Parallax Flipping Cards

CSS animated flipping cards From

2019Oct23

ANmarAmdeen

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

ANmarAmdeen

CSS3 Progressbar

A progress-bar in pure CSS3, used before we got Bootstrap :-)

2019Jan14

ANmarAmdeen