| 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WEEKDAY question on year
=CHOOSE(WEEKDAY("1 Jan " &A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
but you could also do =TEXT("1 Jan"&A2,"ddd") -- HTH Bob Phillips (remove xxx from email address if mailing direct) "mrjeep" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
