Im using Excel 2013.
Case: If I type a date in first column, I want the second column automatically filled with a text.
Example: If I type a date between 1/1/2014 to 1/7/2014 in first column, I want the second column filled with "First Week" automatically. If I type a date between 1/8/2014 to 1/14/2014 in first column, I want the second column filled with "Second Week" automatically.
A (Date Formats) B (Text Formats) 1/9/2014 Second Week 1/1/2014 First Week
Thank you.
Is it safe to assume that with the passing of every week into the year you want it to also update to third week, fourth week, fifth week etc?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I think, it is easier for me to filter my monthly data.
well, if you point this formula to your date cell (assuming it is A2) then you at least get the week number... =weeknum(a2)
From there i was trying to figure out how to get you to first week, second week etc based on the week number. But if you come up with a different way, post it as it might be helpful for someone else.
Do you think something like this will work for you?
Formula:
="Week "&WEEKNUM(A1) and copy it down
Week 2 Week 1
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I should have gone for the simplest solution.
Nice answer AlKey.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks