Copy data from two columns to third columns on a condition

Closed
tarek-kamel Posts 1 Registration date Tuesday April 8, 2014 Status Member Last seen April 8, 2014 - Apr 8, 2014 at 06:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 8, 2014 at 11:27 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 8, 2014 at 11:27 AM
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
0