List of Days in Week Number Excel
I have a Date. Ex: 1/1/2017. I have a week number. Ex: WEEKNUM(1/1/2017) = 1. How can I list all 7 days, starting from Monday - Ending on Sunday. Thanks
The way to do it is like this: =Text(A1,"dddd") Or if I understood you correctly, something like this may do the job: =(A1*7)+Date(2017,1,1) to give you the first day in the a1 week. You may add +1 at the end of the formula. In general, some interesting formulas here: http://www.mrexcel.com/archive/Dates/29795.html Edit: Try this : =DATE(Yr,1,1+(Nth-(Dow>=WEEKDAY(DATE(Yr,1,1))))*7)+ Dow-WEEKDAY(DATE(Yr,1,1)) Taken from here: http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear
With week numbers in Row1 (1 in A1) then in A2 copied down to A8 and A2:A8 across to suit: =DATEVALUE("1/1/17")+7*(A$1-1)+ROW()-1
Attempting to search for strings and having syntax errors
Excel Error 1004 when referencing ranges with VBA
Multiple uses of SaveAs freeze Excel
XYScatter Plot Incorrect XAxis when Drawn in Visual Basic?
Why is “if isna vlookup” quicker than “countif”?
PrintLoop mass print all rows of data in file
Look for which cell in a row has a numberic value and return that value to another cell
Check if a matrix is symmetric in Excel and LibreOffice
How to use column letters in VBA
Create a countIfs function that ignores cells with text that has been struck through
Adding and counting values from unique entries
How do I compare two columns in different sheets for non existing values and then copy them to the main sheet?
Is There a Way to Pull Individual Rows from Multiple Sheet Excel
Loop through all the directories and sub-directories with intermediate wildcard patterns
Extract gz and convert csv to xlsx
How do I concatenate cells and ignoring empty cells