| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WEEKDAY question on year
This is an easy one, but my brain just isn't working tonight!! Here's the formula to show the day =CHOOSE(WEEKDAY("1 Jan 2006"),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") Is there a way to have a seperate cell w/ the year (let's say A2) and instead of 2006 in the formula to have = A2, so when you change the year, it automatically updates each day? Thanks -- mrjeep ------------------------------------------------------------------------ mrjeep's Profile: http://www.excelforum.com/member.php...o&userid=34001 View this thread: http://www.excelforum.com/showthread...hreadid=538339 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named range question | Excel Discussion (Misc queries) | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| leap year question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Need totals of values that fall within a given year | Excel Worksheet Functions | |||
Threaded Mode
