> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Archive Collection: Date Functions
- URL: https://nolongerset.com/archive-date-functions/
- Published: 2024-01-10T18:55:00.000Z
- Updated: 2026-05-08T12:38:00.000Z
- Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Date Functions.
- Author: Mike Wolfe
- Tags: Archive, #Import 2026-05-20 02:59

*I've been writing a daily article here since September 1, 2020; that's over 1,200 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). I'm currently on a family vacation, which makes maintaining this streak a bit...tricky.*

*I'm writing this in the *present* tense, but I'm writing it for *future* publication with links to *past* articles. Let's hope the time-space continuum holds up.*

*In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.*

*I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* 

*Enjoy!*

---

## Date Functions

[“Convenience” Date FunctionsThe DateSerial function is easy to write, but it’s not as easy to read. Let’s make our code easier to read with some “convenience functions.”![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/january-2290045_1920.jpg)](https://nolongerset.com/convenience-date-functions/)

[A Safer Alternative to BETWEEN When Filtering DatesThis convenient function generates defensive SQL statements to help you avoid the subtle dangers of the BETWEEN statement when filtering dates.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/architecture-3223843_1920.jpg)](https://nolongerset.com/betweendates/)

[Displaying Human Readable Time SpansThe HumanizedSeconds() and ConvertToSeconds() functions work hand-in-hand to provide a general solution for storage and display of time spans.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/fantasy-2879946_1920-2.jpg)](https://nolongerset.com/displaying-time-spans/)

### Business Day Functions

[Calculating Federal Holidays in VBA: Juneteenth UpdateAn update to my VBA FederalHolidays(), IsBusinessDay(), and WorkingDayCount() functions with support for the new Juneteenth holiday.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/02/Designer--7-.jpeg)](https://nolongerset.com/juneteenth-update/)

[Counting Business Days in VBACounting business days is easy with the WeekDayCount() and FederalHolidays() functions. What’s interesting is how we test the WorkingDayCount() function.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/salt-harvesting-3060093_1920.jpg)](https://nolongerset.com/counting-business-days-in-vba/)

[VBA IsBusinessDay() FunctionA simple function that returns True except for weekends and US federal holidays.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/tie-690084_1920.jpg)](https://nolongerset.com/vba-isbusinessday-function/)

[IsLastBusinessDayOfMonth() FunctionI bet you can’t guess what this function does.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/drink-4559145_1920.jpg)](https://nolongerset.com/islastbusinessdayofmonth-function/)

[Counting Weekdays in VBAThis otherwise mundane function is made a bit more interesting through its use of the little-known VBA backslash operator, which performs integer division.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/marketplace-4911819_1920.jpg)](https://nolongerset.com/counting-weekdays-in-vba/)

[Using TDD to Calculate Holidays in VBAThis article takes you step-by-step through the Test Driven Design process, unencumbered by the complexity of any sort of testing framework.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/sparkler-839806_1920.jpg)](https://nolongerset.com/calculating-holidays-in-vba/)

### Looping By Month Challenge

[Sticky Wicket: Looping by MonthSome programming problems are difficult to solve. Others are difficult to solve clearly.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/county-cricket-2639131_1920.jpg)](https://nolongerset.com/sticky-wicket-looping-by-month/)

[Looping by Month: DateSerialThe first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/agenda-1928419_1920.jpg)](https://nolongerset.com/looping-by-month-dateserial/)

[Looping by Month: Custom FunctionsBy using a couple of custom functions, we can write very readable loops that iterate one month at a time.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/calendar-3109304_1920.jpg)](https://nolongerset.com/looping-by-month-custom-functions/)

[Looping by Month: Lookup TableHave I ever used this method? No. Can I imagine a situation where it could be useful? Maybe. Should I write an article about it? Sure, why not.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/calendar-547619_1920.jpg)](https://nolongerset.com/looping-by-month-lookup-table/)

[Creating a Monthly Lookup TableHaving a table where each record represents a single month can come in quite handy. Let’s create such a table.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/calendar-5606_1920.jpg)](https://nolongerset.com/creating-a-monthly-lookup-table/)

[Looping by Month: Loop Until with DateAddReader Francesco Foti writes in with his own solution to the Looping by Month challenge.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/motor-loop-3260697_1920.jpg)](https://nolongerset.com/looping-by-month-loop-until-with-dateadd/)

### Additional Reading

[Code LibraryBuilding Your LibraryThirteen years ago, I chose to maintain a folder of textfiles rather than a single Access database library. I’ve never once regrettedthat decision.No Longer SetMike Wolfe \[https://nolongerset.com/building-your-library/\]TheDependency TrainLet’s torture a train metaphor to illu…![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/prague-980732_1920.jpg)](https://nolongerset.com/code-library/#hash-datefunctions)