| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Day from year in 1 column & day & month in another
Hi guys, I am quite new to this and I am trying, without a lot of success,
to display the day of the week on which a date falls in column d from the day number in column a, the month number in b and the year in c. I have been playing with =Weekday(concatenate(A1,B1,C1) but I think this is failing because it is adding the cell contents as text! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching month and year column. | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Sum by month and year | Excel Discussion (Misc queries) | |||
![Peter[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
