Two dates with a range

Question

I have two date ranges found in cells (Comp #1) C4 and F6, (Comp #2) C4 and G6, (Comp #3) C4 and H6, (Comp #4) C4 and I6. This extend for 8 additional columns or comparables..

What I'm trying to do is transfer the number found in the D column that correspond with the date range. The date range is determine by cross referencing the date range of the comparable row 6 to the effective date C4. Then copy the corresponding data found in (D) that matched the date range.

Below is a sample for the (G) column comp #2 range G9:G21.

What it should look like Column (G)

                          **January 2025**   Not Available

                      **December 2024**      0.0%

                     **November 2024**   -79.41%

                         **October 2024**   163.4%

                    **September 2024**   254.7%

                          **August 2024**     70.8% 

                               **July 2024**

                              **June 2024**     

If this isn't explained well. Please let me know

Answer 1

B9 = =MLSModeling2!Q512' tab and cell

MLSModeling2!Q512 =Jan 2025 formula =Q7

Q7 = =EDATE (G3,-1)

G3 = =H3-DAY(H3)+1

H3 = =TODAY()

Also, the forum is acting strange

I could send over the entire spreadsheet but it's has confidential data. Theirfore it needs to be handled in a private forum.

Answer 2

What do B9 and down contain? Date values or text values?

P.S. Sorry about the late reply - the brain-dead forum doesn't update correctly:

Answer 3

Hello HansV,

I have right click onto the cell. Went to cell format and tried all of the different number format.

I hit a brck wall

Thanks

Answer 4

HansV,

Thank You., but something didn't work out correctly.

Please note: The F9:F44 range delivered an error message.

It should have a percentage number that orresponds to the percentage number found in the D9:D44 range, that fall with the date range of C4 and F6. That range is cross reference to the date range of B9:B44 and brings over the corresponding percentage number found in the D9 to D44 range. That corresponding number is onlr placed into the cells that were triggered by the date.

I hope that is as clear as mud.

Thanks

Answer 5

In F9:

=LET(d, DATEVALUE("1-"&$B9), IF(AND(d<=$C$4, d>F$6-DAY(F$6)), $D9, ""))

Fill down then to the right (or vice versa)