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
Excel addition of multiple numbers in single cell
How do I autofill code in VBA?
Use excel VBA to update master list based on user input data
Change number format of a cell which inlude currecny using visual basic
Access reading Excel VBA date in US format
Changing a file name and path in a formula (within a macro) to user-defined
Excel conditional formating - conditional on sum of all previous cells and total sum
Consolidating single rows of data from multiple sheets into one - looping the macro?
Excel FInd and Replace Regex Macro
Excel VBA Loop function for all cells
Excel/VBA uncheck checkboxes if madatory field is empty
Excel VBA continually returning 0
Excel VBA: unable to disable DisplayAlert during drag+drop?
How to deal with Cyrillic letters caused error (#REF) in Worksheets (Unicode VBA display and handling), in VBA
Test for drive presence in an Excel 2007 macro before saving
Get all innertext VBA