"Cindi" ha scritto nel messaggio
...
Thanks to all that helped me figure this out. I finally
did get it to work, after trying each suggestion. The
suggestion that I found to work was as follows:
=if(and(today()=date(2004,10,15),today()<=date
(2004,10,24)),1,if(and(today()=date(2004,10,25),t oday()
<=date(2004,11,01)),2,if(and(today()=date
(2004,11,02),today()<=date(2004,11,07)),3,if(and(t oday()
=date(2004,11,08),today()<=date(2004,11,14)),4,if (and
(today()=date(2004,11,15),today()<=date(2004,11,2 1)),5,if
(and(today()=date(2004,11,22),today()<=date
(2004,11,28)),6,if(and(today()=date(2004,11,29),t oday()
<=date(2004,12,06)),7,0)))))))))
Thanks Again for everyone's help!
Cindi
ciao Cindi,
why not:
=VLOOKUP(TODAY(),{38275,1;38285,2;38293,3;38299,4; 38306,5;38313,6;38320,7},2
)
where 38275 is serial number of 2004-10-15
38285 is serial number of 2004-25-10
and so on...
ivano
|