Auto-populate every second day between two given dates
I'm currently using the formula in this article to auto-populate a column of dates between to given dates:
=ArrayFormula(TO_DATE(row(indirect("A"&A2):indirect("A"&B2))))
How can I tweak the formula to give every second date? Column D in the article would then say:
- 01/04/2018
- 03/04/2018
- 05/04/2018
- 07/04/2018 ...and so on.
Solution
It seems like the formula skips a day if the start date is an odd date. Can this be corrected?
=ARRAYFORMULA(FILTER(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2))),
MOD(ROW(INDIRECT("A1:A"&COUNTA(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2)))))), 2)))
- Convert dd-mm-yyyy string to date
- swiftUI - Date Comparison
- Create a Date in js ignoring timezone
- How to shift dates in a pandas dataframe (add x months)?
- Adding time from a string to a Java date: too little is added
- Is there any pattern to format and parse periods in a day, such as 'in the morning', 'in the afternoon' or 'at night'?
- Format of Date in the JavaFX.TableView
- SimpleDateFormat ignores "XXX" if timezone is set to "UTC"
- Invalid date in safari
- Java: epoch date to MM/DD/YYYY
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- If I wanted to work using dates and time going millions of years into the past/future how would I do it?
- Epoch to Date Not Working Properly
- What is going wrong in this target date calculater?
- Error using SimpleDateFormat
- How to calculate number of days between dates?
- Is `new Date(string)` reliable in modern browsers, assuming the input is a full ISO 8601 string?
- Subtract/Add days to a predefined date using Write-Host
- java.text.ParseException: Unparseable date: Mon Apr 08 00:00:00 IST 2013
- How to solve java.text.ParseException: Unparseable date?
- How to parse a date string in a foreign language with go time
- java.text.ParseException: Unparseable date: "2014-06-10T13:37:17.744Z"
- Google Sheets Script new Date() with timezone is providing wrong time
- UnParseable Date Exception :"2015-02-06T16:05:20"
- Error by converting date: Unparseable date in JAVA
- Pandas read_sql_query - date params
- java.text.ParseException: Unparseable date Exception while converting timestamp value to time in java
- DATEDIFF vs (w1.date = w2.date +1) difference? MySQL syntax
- React > PrimeReact > DataTable > Date Filter - Strip Timezone?
- Obtaining last Friday's date