Excel creating day instead of numeric value

Beginner Questions
,
1

:bullseye: What is your goal?

Get the actual numeric value of the date.

:thinking: What is the problem?

When I run my make automation it goes into excel and formats the numeric value of the date into the actual day.

:test_tube: What have you tried so far?

Going to GPT

:camera_with_flash: Screenshots: scenario setup, module configuration, errors

3.png
2.png

1.png
1.png742×284 15.1 KB

2

Hey, I might be wrong, but try making the date format all caps, like MM/DD/YYYY. If that still doesn’t fix it, the problem is probably with the Google Sheets setup itself.

2 Likes
3

Thank you, it was excel