Forum Discussion
find the Sundays in the November moth
Date Time Temp. (°C) Hum (%RH) 11/01/2023 8:00:00 AM 20.7 54.7 11/01/2023 8:05:00 AM 20.6 54.3 11/01/2023 8:10:00 AM 20.1 54.8 11/01/2023 8:15:00 AM 20.6 55.1 11/01/2...
=IF(WEEKDAY(A2,2)=7,TEXT(A2,"dddd"),"")
Attached is an example file with the formula.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.