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

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

Categories

HOME
solr
google-maps
properties
junit
hardware
bitcoin
luigi
mips32
geoserver
sorm
rhel
double
benchmarking
appcelerator-titanium
xamarin.mac
biopython
image-comparison
visualvm
cdb
swtbot
cookie-session
endpoints-proto-datastore
footable
dsolve
eureka-forms
maxlength
week-number
radius
atom-feed
drools-fusion
choropleth
sqlcedatareader
inorder
kinvey
jung
asp.net-mvc-routing
uppercase
get-eventlog
yamldotnet
flops
apache-hive
r6
envelope
redhat-bpm
dataweave
lift
watchdog
mapped-drive
cartography
lighttable
clisp
masm
gear-vr
smartmeter
csla
rollbar
banking
volume-rendering
jake
android-runtime
report-viewer2012
review-board
countdowntimer
mechanize
google-plus-domains
virtual-directory
classname
servant
nscoding
http-accept-header
httpful
sqlsrv
nameerror
acl2
beta-testing
nstablecolumn
event-loop
rich-snippets
mashape
compiler-options
like
jquery-dynatree
zenoss
mysql-num-rows
arbitrary-precision
kiwi
cxf-client
linq-to-lucene
inference
real-time-data
uipicker
ereg
vp8
strtotime
visual-assist-x
in-app
codeigniter-datamapper
fibonacci-heap
layar
windows-live-writer
validationsummary
context-sensitive-help
httpverbs
installshield-2008
application-design
isaserver
pia

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