INPUT month and OUTPUT > Weeks in the month, Start date of Wk & Start date of Wk

Hi excel Experts,
We have a excel file, in which we have to enter following information.

Month (Column C)
Weeks in the month (Column C)
Start date of specific week (Column D)
End date of specific week (Column E)

All we have to do manually, is this possible that we will enter only month in column (highlighted in yellow colour) and basis the month remaining/following columns will be auto-filled.
Weeks in the month (Column C)
Start date of specific week (Column D)
End date of specific week (Column E)

Please help us to complete this task.
Thanks in advance.

Ravindrak

Try this in D4:

=WORKDAY.INTL(D3+1,-1,"0111111")

in D5:

=D4+7

in E4:

=D4+6

in C4:

=WEEKNUM(D4)

For a row (C4: E4) it is working as expected

How will fill remaining information in range i.e. C5:E8
Kindly advise

Thanks in adavance.
RavindraK

Please revert
Thanks in adavance.
RavindraK

Hi excel Experts,
Please revert
Thanks in adavance.
RavindraK

See attached:

Thanks a lot for your response,
however, in case of, Dec'2018 there are 6 weeks

Start date End date
Month Dec-18 01-Dec-18 31-Dec-18
Week Numbers 48 26-Nov-18 02-Dec-18
49 03-Dec-18 09-Dec-18
50 10-Dec-18 16-Dec-18
51 17-Dec-18 23-Dec-18
52 24-Dec-18 30-Dec-18
53 31-Dec-18 06-Jan-19

And if we added one more line i.e. for week 53, it is OK for Dec'2018, but it is NOT OK for other months with 5 weeks
for example. in Aug'18, there 5 weeks but as we added one more line belwo 5 weeks, week 36 showing wrongly, which is of Sep'2018 not in Aug'2018

Start date End date
Month Aug-18 01-Aug-18 31-Aug-18
Week Numbers 31 30-Jul-18 05-Aug-18
32 06-Aug-18 12-Aug-18
33 13-Aug-18 19-Aug-18
34 20-Aug-18 26-Aug-18
35 27-Aug-18 02-Sep-18
36 03-Sep-18 09-Sep-18

Weeks information is to be appeared for only weeks in a specific month; It should appeared 5 weeks (31 to 35) in Aug'18 weeks whereas in Dec'18 it should appeared 6 weeks (48 to 53)


Thanks in advance
Kindly advise.
RavindraK

in D9:

=IF(MONTH(D8)<>MONTH(D8+7),"",D8+7)

in C9:

=IF(D9="","",WEEKNUM(D9))

in E9:

=IF(D9="","",D9+6)

Great, it is done as expected.
Thanks for your works !!
Ravindrak