"Automated" date function with week number and associated month

[trolle]

If I have a cell containing a date (e.g. a day or month) I know that I can drag it across or down and Excel automatically fills in the next logical day or month.

I also know that I can the same with numbers (e.g. week numbers).

Does Excel have a way to associate a week number with a month?

I have attached a file which should explain my question.

Basically, I work with a lot of time-related data (i.e. week numbers and months). I prefer to be able to drag and automatically fill-in the appropriate cells instead of manually entering and changing the date-related data.

[Glenn Kennedy]

Try C1 (copied across): =B1 +7

and in B2, copied across =WEEKNUM(B1)

you should also read Excel's help info on WEEKNUM, as it isn't entirely straightforward.

[trolle]

Thank you very much.
I should have Googled the WEEKNUM function; didn't know it existed.

A little confusing with the return_type, and the weeks do not match perfectly in December my paper calendar, but it'll do (Excel is showing 53 weeks in 2017, while my paper calendar has 52).

[avk]

Refer attach file.
In "C1" =INT(B1)+1 copy paste right as per your range.
In "B2" =WEEKNUM(B1) copy paste right (For week number)
In "B3" =DAY(B1) For day number
In "B4" =month(B1) For Month number
In "B5" =year(B1) For Year

[Glenn Kennedy]

That's why I suggested reading the excel help. there are various definitions of Week 1... your paper calendar and excel may not be using the same definition.