excel


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

Related Links

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

Categories

HOME
scadalts
dll
multidimensional-array
local-storage
payment
jupyter-notebook
accounting
google-places-api
google-home
inform7
worksheet-function
dynamics-ax-2012
double
smt
zillow
serenity-bdd
selenium-rc
cpu-registers
packet-capture
git-clone
autoload
mahapps.metro
induction
gearman
javabeans
word
transfer-function
fixtures
product-key
crossfilter
kernel-module
dos
ngrx-effects
google-console-developer
paypal-adaptive-payments
enterprise-library-6
gear-vr
crypto++
optional
powerview
machinekey
svg-edit
reportviewer2008
dart-polymer
ubuntu-15.10
pxe
groovy-eclipse
amazon-mobile-analytics
firefox-addon-bootstrap
xcode4
android-context
zshrc
qubole
openembedded
dotdotdot
soundex
mashape
file-attributes
iec61131-3
sqloledb
componentkit
tokumx
apache-tomee
xcode-instruments
openacs
dav
pixate
invalidation
maptiler
activator
zebra-puzzle
nsfontmanager
dbase
hierarchyid
rs485
icommand
struts2-tiles-plugin
django-staticfiles
readelf
jquery-mobile-collapsible
trusted-timestamp
django-sessions
visual-assist-x
grit
springmockito
contentflow
osx-gatekeeper
windows-networking
windows-explorer
winqual
trackback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App