Export to Excel - issue with dates from formula column

Platform discussions
,
1

Hi Support,

I have a formula column (“Final delivery Date”) set to return a date from 2 other columns:
FORMAT_DATE(IF({NL - New delivery date}=“”,{NL - Delivery date},{NL - New delivery date}),“DD/MM/YYYY”).

This works okay in Monday.com: I can sort by date, but filtering means manually selecting each date, unlike Monday’s own DATE column which allows filtering on This Week, Last Week, etc.)

However, when I export to Excel, the date in “Final Delivery Date” is not recognised as a date in Excel. I have tried changing the date format to DD/MM/YY and YYYY/MM/DD with no effect.

The only solution seems to be manually clicking in each cell to get it to recognise the data. Is there a way to get this export working so Excel recognises the date?

Thanks,

image
image383×607 21.2 KB

2

Hi JS_CIC

If your exported sheet is always the same layout you should be able to train a macro to do those repetitive tasks for you. When you have one of those you can activate it at the click of a button.

I’m trying to set up an automated data collection and this is part of my step so I hope it helps you! I’m pretty new to macros but they are super handy and a few youtube videos should help you set it up.

Cheers,

Elliot.