| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return the day of week for 1 January
I want to find the day of the week on which the 1st Jan falls in the year I input. For example: in A1 all I want to enter is a year e.g. 2006. In B1 I want a formula that will return the value SUNDAY. I can get the formula to work if I enter 1/1/06 in A1 but I just want to enter the year. I tried using Concatenate to add 1/1/ to the value in A1 but couldn't get excel to recognise the concatenation as a date. Any ideas?
thanks mjd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
| Return Sundays date of current week | Excel Worksheet Functions | |||
| user defined function | Excel Worksheet Functions | |||
| Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
Linear Mode
