dategoogle-sheetsarray-formulasgoogle-sheets-formula
How to convert dates pulled from IMPORTXML to actual dates
I'm importing a 45-day weather forecast from https://weather.interia.com/long-term-forecast-chicago,cId,49700
The dates are listing like so:
1.11
2.11
3.11
4.11
5.11
6.11
7.11
8.11
9.11
10.11
11.11
12.11
13.11
14.11
15.11
16.11
17.11
18.11
How can I convert these to actual dates? TO_DATE hasn't worked. I appreciate any help.
Solution
try:
=ARRAYFORMULA(DATE(YEAR(TODAY()), INDEX(SPLIT(IMPORTXML(
"https://weather.interia.com/long-term-forecast-chicago,cId,49700",
"//span[@class='date']"), "."),,2), INDEX(SPLIT(IMPORTXML(
"https://weather.interia.com/long-term-forecast-chicago,cId,49700",
"//span[@class='date']"), "."),,1)))
- How to retrieve the current day of the week?
- GWT get build date
- PHP date() with timezone?
- Comparing text fields that contain dates in Google Sheets
- Carbon and PHP DateTime parse single letters as dates, but not multi-character strings
- Detect daylight saving time in bash
- java.util.Date vs java.sql.Date
- Find all month names between two given date in java
- vba return first row number in column that has todays date or nearest date after today
- Iterate over all last-day-of-the-month dates in a year
- How to set the current date in the gnuplot title
- How can I validate a date in Python 3.x?
- how to use str_to_date (MySQL) to parse two-digit year correctly
- Jquery dd/MM/yyyy date format validation
- Duration between two dates in Ruby (Rails)
- How to generate a Date from just Month and Year in Java?
- In Swift 5, how do I increment a date property by some interval and then run the function with that new future date?
- Last day of quarter
- Split timeperiods by referring dates in another table
- for loop to generate time list in javascript
- Implementing range between dates in a window
- How to calculate difference between dates by group in SAS
- Why does DateTime.Now to the yyyy-mm-dd format give me incorrect month results?
- How to get current date and time in WordPress?
- Date change function in PHP
- Best approach to remove time part of datetime in SQL Server
- How to get year/month/day from a date object?
- How to update a field in React Hook Form based on other fields' values?
- How to check if there is a weekend between two dates in php?
- Get next day, skip weekends