Thread: Day of week for pre 1900 dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default Day of week for pre 1900 dates

If you download John Walkenbach's XDATE functions as suggested above
then with your year, month, day, e.g. 1685, March, 21 in A1, B1, C1
then use this formula to get weekday in text format, e.g. Wednesday

=TEXT(XDATEDOW(XDATE(A1,MONTH("1 "&B1),C1)),"dddd")

note: assumes your using Excel's default 1900 date system. For the
example above it gives me "Wednesday"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559593

Reply With QuoteReply With Quote