I’m trying to set it up so that my google sheets will update every week or so and then add an event to google calendar then name it "week #) but I can’t see to get the date to work

and the google calendar error is here

If there is a simpler solution please let me know to calrify I just want to make an event every sunday that says week 1, week 2, week 3 and so on
Hi there and welcome to our community ![]()
Your date format isn’t valid as stated in the error, can you please try formatting it in google sheets like this ? 9/7/2025 ?
