How to extract date from date/time

Options

Sallie Huang

Sallie Huang ✭

01/21/21 in Formulas and Functions

May someone please assist? How do I extract the date from "1/15/2021 9:24:55 AM"?

0 ·

Answers

Mark Cronk ✭✭✭✭✭✭

01/22/21
Options
=DATEONLY([insert colum name]@row)
Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
0 · Share on Facebook Share on Twitter
Sallie Huang ✭

01/22/21
Options
Hi Mark,
I have tried the formula and it didn't work. The cell returned with "#INVALID DATA TYPE".
Regards,
Sallie

0 · Share on Facebook Share on Twitter
Mark Cronk ✭✭✭✭✭✭

01/22/21
Options
Hi Sally,
Confirm that the column with the formula is a date column.
Work?
Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula to surface specified data and date from project task
I am trying to to surface to latest EOT from the task to row 1 on EOT Stage, and respectively the corresponding End Date to EOT End Date row 1. We may state EOT 1 - 5 on the project sheet, but it will only take effect the date is filled in. Therefore, the latest EOT need not necessary be 5. But in the following example, I…
I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in
I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column. =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5)) or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))…
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.