Week number calculation cell

[anonymust]

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

 

[James006]

Hi,

Ron has very nicely summarized the challenge of the week number : Week numbers in Excel

HTH

 

[anonymust]

=WEEKNUM(D11;0)

Ahhh! i see where I went wrong..


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