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 […]
Tag: TEXT function
TEXT and MONTH Function in Google Sheets with Example
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.

