Week number calculation cell

anonymust

New Member
Joined
Dec 17, 2011
Messages
21
Hey guys and gals,




I need some help on getting a week number calulated .. I've tried to use WEEKNUM function, but that didnt seem to work out right for me when I saved the file (based on computer system, it always changes


In my excel file (uploaded here on Mega.co.nz) I would like cell C3 to calculate what week it is bases on the contents of cell C9:C16 (or just on cell C9)


Would be cool also if I can just click on cell C3 and select a date (the sunday of that week) from a calendar function


Both ways I would like to see, so I can learn them myself and play around with them


P.s. i would like the file to print as you currently see it (so if anything else it added in a cell it wont print), and take note the date format is DD/MM/YYYY
Gracias
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Code:
=WEEKNUM(D11;0)


Ahhh! i see where I went wrong..


I used 0 instead of 1 when i was testing it out.
 
Upvote 0

Forum statistics

Threads
1,223,054
Messages
6,169,834
Members
452,284
Latest member
TKM623

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top