Copy Date from Formula to another Sheet not working
Hello-
I have one sheet with a Form attached. When users submit their form, I have a formula that will convert their some of their selections into start and end dates.
Sheet 1
I then have a second sheet where all rows are copied from the first sheet that serves as a Calendar view for the created dates. I did this because I believe that I cannot have a formula running on a date column? It has to be straight dates?
Sheet 2
Well, everything is working just fine except the dates that copy from sheet 1 are showing up on sheet 2, but are not formatted as a date. I click the column and it says it's a date, but unless I manually click the date itself my start and end dates will not show on calendar view.
What am I doing wrong? Do I need to change my formula to make the results specifically say it is a date? Are my dates incorrectly formatted?
Best Answer
-
In your first formula, the quotes around the dates are making the formula output a text string that only looks like a date. You will need to replace
"mm/dd/yy"
with
DATE(yyyy, mm, dd)
Answers
-
In your first formula, the quotes around the dates are making the formula output a text string that only looks like a date. You will need to replace
"mm/dd/yy"
with
DATE(yyyy, mm, dd)
-
That was it Paul, thank you so much. I'm still new and I wasn't sure how to to convert the string in the If statement. Works perfectly now!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!