• last year
Function TOTAL(a As Integer, B As Integer)
TOTAL = a + B
End Function
-----------------------------------------------------------
Function TodayDayName(a As Date)
TodayDayName = WorksheetFunction.Text(a, "DDDD")
End Function

Supporting File.

https://drive.google.com/file/d/1HDiCEQ6S-0I3gtEsXZHtPAPL-6e-aypz/view?usp=share_link