Copy Date from Formula to another Sheet not working

AnemonePoppy

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?

Paul Newcome

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)

Paul Newcome

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)

AnemonePoppy

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!

Paul Newcome

Happy to help. 👍️