Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another Date Formula Request
I have 2 columns one with dates (D7:D37) and another with values
corresponding to the dates in the same row(E7:E37). I actually need 2 examples. I'd like to see the date in D column prior to the date that is 6 months prior to today with the corresponding value and in addition i hope to be able to see the 1st date in columnd D that is after 6 months prior to today and it's corresponding value. I'm trying to put these values in A41 and B 41 and A42 and B42. Thanks for your help! |
#2
|
|||
|
|||
Just so what I need seems more clear. Here is an example of what I have.
Columm D from rows 7-11 5/14/04 7/20/04 8/1/04 8/5/04 10/26/04 Column E from rows 7-11 1 2 1 1 2 Today being 1/21/05 I'd like to see in A41:7/20/04 A42:2 B41:8/1/04 B42:1 Thanks "Qaspec" wrote: I have 2 columns one with dates (D7:D37) and another with values corresponding to the dates in the same row(E7:E37). I actually need 2 examples. I'd like to see the date in D column prior to the date that is 6 months prior to today with the corresponding value and in addition i hope to be able to see the 1st date in columnd D that is after 6 months prior to today and it's corresponding value. I'm trying to put these values in A41 and B 41 and A42 and B42. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |