Find the Google Sheet formula you’re after to solve your problem, with these examples. Click the link to read the post. Posts without active links are in the works and coming soon.
Have a specific question? Drop me a line here.
> How do I get the first and last days of this same month last year?
> How do I get the date only from a timestamp? (i.e. how can I remove the time component)
> How do I get the time only from a timestamp? (i.e. how can I remove the date component)
> How do I get the first and last days of the year?
Formulas for manipulating data
> How do I do basic web scraping with the IMPORT formulas in Google Sheets? (examples from the New York Times, the Washington Post and Business Insider)