I have run out of arguments for nested IF statement
On Sun, 19 Mar 2006 04:13:34 -0600, christopherp
wrote:
Hi Guys,
For the majority of my Uni assignments the due date is given as a week
number (eg assignment given week 5 - assignment due week 12)
I am trying to devise a way of displaying the current week number of
the semester. I will then use this result for a number of other
procedures (cond formatting etc...)
The date in cell $F$3 is the first day of the semester.
I have put together a formula which works fine until I reach 7 nested
IF arguments. Can anyone help me shorten the formula or suggest an
alternative way to do what I would like to do:
Please see below for formula
Thanks in advance :)
Chris
=IF((TODAY()=($F$3+91)),"Week 13",IF((TODAY()=($F$3+84)),"Week
12",IF((TODAY()=($F$3+77)),"Week 11",IF((TODAY()=($F$3+77)),"Week
11",IF((TODAY()=($F$3+70)),"Week 10",IF((TODAY()=($F$3+63)),"Week
9",IF((TODAY()=($F$3+56)),"Week 8",IF((TODAY()=($F$3+56)),"Week
8",IF((TODAY()=($F$3+49)),"Week 7",IF((TODAY()=($F$3+42)),"Week
6",IF((TODAY()=($F$3+35)),"Week 5",IF((TODAY()=($F$3+28)),"Week
4",IF((TODAY()=($F$3+21)),"Week 3",IF((TODAY()=($F$3+14)),"Week
2","not at uni"))
Well, the formula =INT((today()-$F$3)/7)+1 will give you the current semester's
week number.
So maybe something like:
="Week " & INT((TODAY()-$F$3)/7)+1
--ron
|