Online Tutorial for Data Analysis and Automation
The DATE, DAY, and MONTH Functions in Google Sheets are incredibly useful when you need to extract specific pieces of information from a full date. For instance, you might need to find out the exact day of the month or pull just the month or year from a given date. These functions make it quick […]
Convert Numbers into Dates Have you ever looked at a column of numbers in Google Sheets and thought, “These are supposed to be dates, but they don’t look right!”? Don’t worry—you’re not alone! This is a common issue, but luckily, there’s a quick and easy solution. In this blog post, I’ll show you how to […]
Use the TEXT and MONTH functions in Google Sheets to get the day name and month number from any date. Worked example with 17 dates, format codes, counts, quarters, weekend flags and common fixes.