Returning a Date with Multiple Criteria Lookup Values


A

Almellac

I'm stuck on how to write a formula that will look at the followin
criteria:

Today's date is 2/12/13 + 6 weeks = 3/24/13

Look at value of A,B,C,D on 3/24 and determine if that is negative.

If that number is a negative, return the Monday date the followin
week.

If that number is a positive, return the Monday date of the firs
negative value after 3/24/13.

For example, the correct value returned for column A would be 3/25/13
and for column B would be 4/15/13.


Date A B C D
02/10/13 70,000 90,000 2,053,550 0
02/17/13 355,604 404,132 2,976,947 63,256
02/24/13 20,908 369,456 4,496,047 68,048
03/03/13 -643,288 383,280 5,313,147 -201,160
03/10/13 452,016 545,104 6,610,247 329,632
03/17/13 191,820 669,928 7,439,847 899,424
03/24/13 -492,876 277,752 7,457,447 1,203,216
03/31/13 -1,217,572 415,576 8,618,047 1,196,008
04/07/13 -1,641,268 293,400 7,555,647 1,294,800
04/14/13 -2,520,964 -193,776 8,483,247 935,592
04/21/13 -3,505,660 -845,952 7,060,847 504,384
04/28/13 -4,390,356 -1,248,128 5,768,447 -46,824
05/05/13 -5,339,052 -1,700,304 3,986,047 -553,032
05/12/13 -6,323,748 -2,352,480 2,243,647 -704,240
05/19/13 -7,308,444 -3,004,656 351,247 -1,255,448
05/26/13 -8,293,140 -3,656,832 -1,651,153 -1,806,656
06/02/13 -9,277,836 -3,999,008 -3,963,553 -2,357,864



I hope I was able to define my problem clearly, is there a way to d
this in one formula
 
Ad

Advertisements


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