Day of week from date?

[Terry Pinnell]

Does anyone have a formula that will return the day of the week (e.g
Friday), given a date (e.g d = 3, m = 4, y = 2004) please? I'm looking
for a mathematical formula or algorithm, not an Excel function.

 

[Steve Yandl]

If your date is in A1,
=IF(WEEKDAY(A1)=1,"Sunday",IF(WEEKDAY(A1)=2,"Monday",IF(WEEKDAY(A1)=3,"Tuesday",IF(WEEKDAY(A1)=4,"Wednesday",IF(WEEKDAY(A1)=5,"Thursday",IF(WEEKDAY(A1)=6,"Friday","Saturday"))))))

Steve Yandl

 

[Terry Pinnell]

If your date is in A1,
=IF(WEEKDAY(A1)=1,"Sunday",IF(WEEKDAY(A1)=2,"Monday",IF(WEEKDAY(A1)=3,"Tuesday",IF(WEEKDAY(A1)=4,"Wednesday",IF(WEEKDAY(A1)=5,"Thursday",IF(WEEKDAY(A1)=6,"Friday","Saturday"))))))

Steve Yandl

Thanks, but I'm looking for a function-free 'formula' in the familiar
sense, not an 'Excel Formula'. From subsequent research, it will
probably be something derived along these lines:
http://en.wikipedia.org/wiki/Zeller's_congruence