Day of week from date?

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
T

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 said:
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
Click to expand...

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
 
Back
Top