On the registration page the volunteer can pick a date e.g. 12/2/2019 and the spreadsheet figures out what day of the week it is. e.g. Monday This is done by using the TEXT function in excel with a format of "gggg" in Italian ("dddd") in English https://support.office.com/en-us/article/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c Formula `=IF(B5="","",TEXT(B5, "gggg")` If B5 is empty, display empty otherwise display the day of the week. Note: this only works in italian given the usage of gggg
Activity