Help Needed

A

AshKhan

i need help with something that looks simple but i cant for the life o
me work it out

In cells E10 i want to input a date e.g 01/02/12
i want the worksheet to automatically work out
what target i have hit in cell G10

my targets are
13 weeks
26 week
39 week
52 week
52+

i want the cell G10 to populate the content into one of the 5 target
based on the date i put in

so if i input

01/02/12 cell G10 should automatically have text entered "39 Week"

i also want the formula to work in all cells E10 and G10 onward
 
J

jack_n_bub

AshKhan;1606500 said:
i need help with something that looks simple but i cant for the life o
me work it out

In cells E10 i want to input a date e.g 01/02/12
i want the worksheet to automatically work out
what target i have hit in cell G10

my targets are
13 weeks
26 week
39 week
52 week
52+

i want the cell G10 to populate the content into one of the 5 target
based on the date i put in

so if i input

01/02/12 cell G10 should automatically have text entered "39 Week"

i also want the formula to work in all cells E10 and G10 onwards

Hi,

I would recommend an easy VBA function for this purpose but if you ar
looking for something in Excel, here is a formula that works for thi
situation.

=IF(INT((TODAY()-A2)/7)<=13,"13 Weeks",IF(INT((TODAY()-A2)/7)<=26,"2
Weeks",IF(INT((TODAY()-A2)/7)<=39,"3
Weeks",IF(INT((TODAY()-A2)/7)<=52,"52 Weeks","52+ Weeks"))))

This formula assumes that your date is in Cell A2.

Please let me know if this works for you.

Prashan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top