Zapier Date not showing as Date in Excel

Hi ​@paula_gfs, hope you're doing well!

It is curious that once the column format is set to date with “dd/mm/yyyy”, this issue would persist.

Do the cells of your date column in Excel have a formula, or are they completely blank? If you’re able to share a screenshot of the formatting of a blank cell, that would be great (please censor any personal/sensitive information)!

Looking forward to hearing from you 😊

Hi ​@paula_gfs 

Here’s an alternative…

Use Airtable instead of Excel.

Airtable has Date field types. (INFO)

For Date field types you can specify the date format.

Also, there are Formula field types, and you can use a formula to manipulate the date format.

There are other advantages of using Airtable instead of Excel in automations.

​@paula_gfs 

Feedback from ChatGPT…

Thank you all for your responses.

Sbastian:  I’ve attached a couple screen shots. 

As you can see the date posted from Zapier is showing as text. When I press F2 and then press enter on the date it reverts to the correct format Excel is expecting it to be (as shown in the previous records).

The next scren shot is hte format I’m using in Excel for this field (column)

Thanks Troy - but really need to use Excel for various reasons

I will try that and let you know how I go

thanks

No luck with the 

DATEVALUE only works when the field only has a date but if it has a time in it as well - such as this: 

it ends with ERROR

Just really want to put a date in Excel from Zapier that comes in as a date not as a text field - so frustrating.

Any help woulf be really appreciated

Thanks

Hi ​@paula_gfs,

I recommend contacting our Support Team about this issue so they can examine the Zap and its logs more closely, as they have the appropriate tools for that. You can reach our Support Team here:  https://zapier.com/app/get-help

Hopefully, this helps.