Active week with dates

[kuzna26]

Hey guys,

Please I a list of weeks and dates
I.e Week 1 ( Jan 1-8 ) Week 2 ( Jan 9-14) Week 3 ( 15 -22) up to Week 52 ( Dec 24-31)
for instance today is jan 15 , therefore as soon as open the spreadsheet , I would like to have this active Week 3 shown as well as
last and next week



Please any help

[alvin-chung]

Hi kuzna26, if you just want to hide other weeks perhaps you can try using Conditional Formatting to hide/show it?
I.e. make the font of all your weeks as White (or same as cell background), then use CF to make last/this/next week font to something visible, say Black...



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[kuzna26]

Hi kuzna26, if you just want to hide other weeks perhaps you can try using Conditional Formatting to hide/show it?
I.e. make the font of all your weeks as White (or same as cell background), then use CF to make last/this/next week font to something visible, say Black...



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Please would send me how to use CF to do so , please if you can send me a spreadsheet

Thanks

[alvin-chung]

Sure, but perhaps it's much easier/speedy if you could share a sample spreadsheet and we could try on it thereafter?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[kuzna26]

Sure, but perhaps it's much easier/speedy if you could share a sample spreadsheet and we could try on it thereafter?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Please find attached the spread sheet
Thank you ,

[alvin-chung]

It took me a while to realize that it was in Portugese language and your week start from Saturday
I had modified your dates in row 5 to real dates for cf calculation and created 2 cf so that each time you re-open the file current week will be highlighted in orange and last/next week will be highlighted in gray

See attached...



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[kuzna26]

It took me a while to realize that it was in Portugese language and your week start from Saturday
I had modified your dates in row 5 to real dates for cf calculation and created 2 cf so that each time you re-open the file current week will be highlighted in orange and last/next week will be highlighted in gray

See attached...
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Thank you for the help , just a quick question is there a way to keep the active week and the others two in a specific cell range
i.e
C1:G29 for last week,
H1:N29 Active cell
O1:T29 Next week


Thanks

[alvin-chung]

You're welcome

Provided that you do not need to modify the contents you can create formulas for your weeks/days/date in a fixed range, else I would imagine that vba needs to be involved.




_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[kuzna26]

You're welcome

Provided that you do not need to modify the contents you can create formulas for your weeks/days/date in a fixed range, else I would imagine that vba needs to be involved.




_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

hello Alvin.

yes the dates will be in fixed range, Could please show me how to create these formula;

Thanks

[alvin-chung]

Try this:
1. C3="Last Week", J3="This Week", Q3="Next Week"
2. Format C3:I29 and Q3:W29 as gray, J3:P29 as orange
3. Enter this formula in C5 and copy till W5

Please Login or Register  to view this content.

4. Format C5:W5 as dd

And whenever you open the workbook, the dates in C5:W5 will always be showing from last week till next week.



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[kuzna26]

Try this:
1. C3="Last Week", J3="This Week", Q3="Next Week"
2. Format C3:I29 and Q3:W29 as gray, J3:P29 as orange
3. Enter this formula in C5 and copy till W5

Please Login or Register  to view this content.

4. Format C5:W5 as dd


Thanks,


And whenever you open the workbook, the dates in C5:W5 will always be showing from last week till next week.



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Hello Alvin ,
Please show me on the attached file ,
I couldn't figure it out and I am sorry

[alvin-chung]

No worries, see if this is what you're looking for.



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin