How can I get list of dates between two dates

Ask the Community
1

How can I get list of dates between two dates, in my case i want to count effort for specific month and exclude employees vacations, so I’m using networkingdays function which accept list of holidays.

2

This thread might help. Count specific weekdays between two dates / date range - #2 by Pch

You’ll probably want to use the Sequence formula. Coda formulas, formula library, formula cheat sheet - Coda

With more detail we might be able to assist more.

3

@Mohammed_Abdelkarim I’m guessing something like this formula is what you’re looking for? Sequence(thisRow.[Start Date],thisRow.[End Date]).FormulaMap(CurrentValue.ToDate())

4

can probably prompt the AI to make that list for you