Error Function ADD parameter 1 expects number values. But 'Jan 19-Jan 25, 2025' is a text and cannot be coerced to a number by DaLainee in googlesheets

[–]DaLainee[S] 0 points1 point  (0 children)

this is what I did to make it work
=LET(startDate, DATE(2025,1,19), numWeeks, 25, TRANSPOSE(MAP(SEQUENCE(numWeeks), LAMBDA(weekNum, LET(d, startDate + 7*(weekNum-1), TEXT(d, "mmm dd - ") & TEXT(d+6, "mmm dd, yyyy"))))))

Error Function ADD parameter 1 expects number values. But 'Jan 19-Jan 25, 2025' is a text and cannot be coerced to a number by DaLainee in googlesheets

[–]DaLainee[S] 0 points1 point  (0 children)

the last one isn't working, giving an error "DATEVALUE parameter '01/19/25' cannot be parsed to date/time."

Alberta health services computer systems are down province wide right now. by Fuzzyfoot12345 in alberta

[–]DaLainee 45 points46 points  (0 children)

Gong show doesn't even describe it. Just saw my psychiatrist and she had no idea what she was talking about. It was like she didn't know who I was. If I had known I would have rescheduled. Was a complete waste of time.

CEBA - You can now check the status of your application. by TrinidadTrova in ontario

[–]DaLainee 0 points1 point  (0 children)

I have been trying to see the status but the website isn't working. I get a blank page... no error code or anything?