Copy data from two columns to third columns on a condition [Closed]

Report
Posts
1
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
-
Column A1 containing the current day =today()

From B4:B33 the dates from the beginning of the month till end of the month

From C4:C33 the first column i want to copy from it

From E4:E33 the second column i want to copy from it

What i need now if the date from B4:B33 is > Today to copy from Column C start from today till the end of the month including today & past it in column G
if the date from B4:B33 is < Today to copy from Column E start from the beginning of the month untill yesterday & past it in column G

1 reply

Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi Tarek-Kamel,

Not clear.

If Today must be bigger or smaller then the range B4:B33, then Today will never match any of the value in B4:B33, thus the ranges C4:C33 and E4:E33 will always be copied in it's entirety.

And that is not what you want, right?

Best regards,
Trowa