Can anyone translate this into Access speak?
=TEXT(WEEKDAY(DATE(CalendarYear,1,1),1),"aaa")
Calendaryear being a cell that is changed by the user.
Can anyone translate this into Access speak?
=TEXT(WEEKDAY(DATE(CalendarYear,1,1),1),"aaa")
Calendaryear being a cell that is changed by the user.
something like
weekdayname(weekday(dateserial(calendaryear,1,1),1 ),True)
Thanks again Ajax, works a treat, just have to incorporate it into the database.