getting week start date and end date for multiple weeks

[Naveen N]

Dear Reader,

I need to have a drop down values with Week start and end date (start date and end date concatenated).

For this week the start date is : 4/10/16 and END Date is 4/16/16

I am using the below formulas to get the week start date and end date for current week.

Start Date: =TODAY()-WEEKDAY((TODAY())+1
END Date: = TODAY()-WEEKDAY((TODAY())+7

And I am using the below formula to concatenate

=TEXT(C33,"mm/dd/yy") & "-" & TEXT(D33,"mm/dd/yy")

Need to have current week and next week start date and end dates in the drop down and the dates need to changes automatically every week?

Please suggest how to achieve this.

Regards,

Naveen n

 

[Villalobos]

Hi,

Is this proposal help for you?

 

[Naveen N]

HI,

The proposed solution helps, the only issues I am having is next week I will lose the below value from drop down:
10/04/2016 - 16/04/2016

I wanted Prevoius week values and cur

 

[Naveen N]

HI,

The proposed solution helps, the only issues I am having is next week I will lose the below value from drop down:
10/04/2016 - 16/04/2016

I wanted Prevoius week values and current value to be in drop down.
Next week I need the drop down values to have
10/4/2016 - 16/04/2016
17/4/2016 -23/4/2016

Regards,
Naveen n

 

[Villalobos]

Hi,

Check out this file. The last 2 entries (in column C) are displayed in the drop down list.

 

[Naveen N]

Thanks you. This solves my problem.