Date+Time 57

Anything for date and time

Sorted from new to old.

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Sun 9AM

PrevWeekday

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

Feb1

Get boot time

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

2024Sep6

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

UnUnixDateTime

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

2024Jan6

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

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

Total14Round

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

2023Aug8

1 2 3 4