copy and replace date from other tab in row with the same month

[guscy]

APTS Common Expenses 2020.xlsx
	A	B	C	D	E	F	G
1	22/6/2020
2	ΔΙΑΜΕΡΙΣΜΑ 01
3	ΗΜΕΡΟΜΗΝΙΑ	ΠΕΡΙΓΡΑΦΗ	ΟΦΕΙΛΟΜΕΝΟ ΠΟΣΟ	ΠΛΗΡΩΘΕΝ ΠΟΣΟ	ΥΠΟΛΟΙΠΟ
4	1/1/2020	ΥΠΟΛΟΙΠΟ 2019			0,00		1
5	5/1/2020	ΙΑΝ	-5	5	0,00		2
6	5/3/2020	ΦΕΒ	-5	6	1,00		3
7	10/6/2020	ΜΑΡ	-5	7	3,00		4
8		ΑΠΡ	-5		FALSE
9		ΜΑΪ	-5		FALSE
10		ΙΟΥΝ	-5		FALSE
11			-5		FALSE
12		ΙΟΥΛ	-5		FALSE
13		ΑΥΓ	-5		FALSE
14		ΣΕΠ	-5		FALSE
15		ΟΚΤ	-5		FALSE
16		ΝΟΕ	-5		FALSE
17		ΔΕΚ	-5		FALSE
18					FALSE
19					FALSE
20					FALSE
21					FALSE
22					FALSE
23	ΣΥΝΟΛΟ ΠΛΗΡΩΜΩΝ:			18
24	ΣΥΝΟΛΟ:	ΠΡΟΠΛΗΡΩΜΗ			3,00
APT 01

Cell Formulas
Range	Formula
A1	A1	=TODAY()
A5:A22	A5	=IFERROR(IF(INDEX(myΗΜΕΡΟΜΗΝΙΑ,MATCH(ROW(A1),APT_01,0),1)>0,INDEX(myΗΜΕΡΟΜΗΝΙΑ,MATCH(ROW(A1),APT_01,0),1),0),"")
E5:E22	E5	=IF(A5<>"",ROUND(SUM((E4+C5)+D5),2))
G4:G22	G4	=IF(A4="","",IF(A4<=$A$1,ROW()-3,""))
D5:D22	D5	=IFERROR(IF(INDEX(myΠΟΣΟ,MATCH(ROW(A1),APT_01,0),1)>0,INDEX(myΠΟΣΟ,MATCH(ROW(A1),APT_01,0),1),0),"")
D23	D23	=SUM(D5:D22)
B24	B24	=IF(E24<0,"ΟΦΕΙΛΟΜΕΝΟ ΥΠΟΛΟΙΠΟ",IF(E24=0,"--------------------------",IF(E24>0,"ΠΡΟΠΛΗΡΩΜΗ")))
E24	E24	=OFFSET($G$4,MATCH(LARGE($G$5:$G$22,1),$G$5:$G$22,0),-2)

Named Ranges
Name	Refers To	Cells
'APT 01'!Print_Area	='APT 01'!$A$2:$E$24	D6, A6

APTS Common Expenses 2020.xlsx
	A	B	C	D
1	ΗΜΕΡΟΜΗΝΙΑ	ΠΕΡΙΓΡΑΦΗ	ΠΟΣΟ	ΔΙΑΜ 01
2	5/1/2020	ΔΙΑΜ 01	5	1
3	5/3/2020	ΔΙΑΜ 01	6	2
4	10/6/2020	ΔΙΑΜ 01	7	3
BANK ACCOUNT STATEMENT

Cell Formulas
Range	Formula
D2:D4	D2	=IF($B2=D$1,COUNTIF($B$2:$B2,$B2),0)

Cells with Data Validation
Cell	Allow	Criteria
B2:B4	List	=ΕΠΙΛΟΓΕΣ

Hi,

Date is copy from tab BANK ACCOUNT STATEMENT in TAB APT 01 column A.
I need in tab APT 01 column A to have pre-enter dates starting from A5 with 1/1/2020, A6 1/2/2020 to 1/12/2020 and then if a payment is made date from tab BANK ACCOUNT STATEMENT to replace pre-enter date but ir row with same month. Others date must not affected.
Is that possible?

Thanks in advance,

 

[guscy]

APTS Common Expenses 2020_FINAL.xlsx
	A	B	C	D	E	F	G
1	25/6/2020
2	ΔΙΑΜΕΡΙΣΜΑ 01
3	ΗΜΕΡΟΜΗΝΙΑ	ΠΕΡΙΓΡΑΦΗ	ΟΦΕΙΛΟΜΕΝΟ ΠΟΣΟ	ΠΛΗΡΩΘΕΝ ΠΟΣΟ	ΥΠΟΛΟΙΠΟ
4	1/1/2020	ΥΠΟΛΟΙΠΟ 2019			2,00		1
5	2/5/2020	ΙΑΝ	-28,99	30	3,01		2
6	3/5/2020	ΦΕΒ	-28,99	30	4,02		3
7	7/5/2020	ΜΑΡ	-28,99	30	5,03		4
8	9/5/2020	ΑΠΡ	-28,99	30	6,04		5
9		ΜΑΪ	-28,99
10		ΙΟΥΝ	-28,99
11
12		ΙΟΥΛ	-28,99
13		ΑΥΓ	-28,99
14		ΣΕΠ	-28,99
15		ΟΚΤ	-28,99
16		ΝΟΕ	-28,99
17		ΔΕΚ	-28,99
18
19
20
21
22
23	ΣΥΝΟΛΟ ΠΛΗΡΩΜΩΝ:			120
24	ΣΥΝΟΛΟ:	ΠΡΟΠΛΗΡΩΜΗ			6,04
APT 01

Cell Formulas
Range	Formula
A1	A1	=TODAY()
A5:A17	A5	=IFERROR(IF(INDEX(myΗΜΕΡΟΜΗΝΙΑ,MATCH(ROW(A1),ΔΙΑΜ_01,0),1)>0,INDEX(myΗΜΕΡΟΜΗΝΙΑ,MATCH(ROW(A1),ΔΙΑΜ_01,0),1),0),"")
A18:A22	A18	=IFERROR(IF(INDEX(myΗΜΕΡΟΜΗΝΙΑ,MATCH(ROW(A14),APT_01,0),1)>0,INDEX(myΗΜΕΡΟΜΗΝΙΑ,MATCH(ROW(A14),APT_01,0),1),0),"")
E5:E22	E5	=IF(A5<>"",ROUND(SUM((E4+C5)+D5),2),"")
G4:G22	G4	=IF(A4="","",IF(A4<=$A$1,ROW()-3,""))
D5:D22	D5	=IFERROR(IF(INDEX(myΠΟΣΟ,MATCH(ROW(A1),ΔΙΑΜ_01,0),1)>0,INDEX(myΠΟΣΟ,MATCH(ROW(A1),ΔΙΑΜ_01,0),1),0),"")
D23	D23	=SUM(D5:D22)
B24	B24	=IF(E24<0,"ΟΦΕΙΛΟΜΕΝΟ ΥΠΟΛΟΙΠΟ",IF(E24=0,"--------------------------",IF(E24>0,"ΠΡΟΠΛΗΡΩΜΗ")))
E24	E24	=IFERROR(OFFSET($G$4,MATCH(LARGE($G$5:$G$22,1),$G$5:$G$22,0),-2),E4)

APTS Common Expenses 2020_FINAL.xlsx
	A	B	C	D	E	F	G	H	I
1	ΗΜΕΡΟΜΗΝΙΑ	ΠΕΡΙΓΡΑΦΗ	ΠΟΣΟ	ΔΙΑΜ 01	ΔΙΑΜ 02	ΔΙΑΜ 11	ΔΙΑΜ 12	ΔΙΑΜ 13	ΔΙΑΜ 14
2	2/5/2020	ΔΙΑΜ 01	30	1	0	0	0	0	0
3	3/5/2020	ΔΙΑΜ 01	30	2	0	0	0	0	0
4	6/5/2020	ΛΟΓΑΡΙΑΣΜΟΣ ΡΕΥΜΑΤΟΣ	20	0	0	0	0	0	0
5	7/5/2020	ΔΙΑΜ 01	30	3	0	0	0	0	0
6	9/5/2020	ΔΙΑΜ 01	30	4	0	0	0	0	0
7				0	0	0	0	0	0
8				0	0	0	0	0	0
9				0	0	0	0	0	0
10				0	0	0	0	0	0
11				0	0	0	0	0	0
12				0	0	0	0	0	0
13				0	0	0	0	0	0
14				0	0	0	0	0	0
15				0	0	0	0	0	0
16				0	0	0	0	0	0
17				0	0	0	0	0	0
18				0	0	0	0	0	0
19				0	0	0	0	0	0
20				0	0	0	0	0	0
21				0	0	0	0	0	0
22				0	0	0	0	0	0
23				0	0	0	0	0	0
24				0	0	0	0	0	0
25				0	0	0	0	0	0
26				0	0	0	0	0	0
27				0	0	0	0	0	0
28				0	0	0	0	0	0
29				0	0	0	0	0	0
30				0	0	0	0	0	0
31				0	0	0	0	0	0
32				0	0	0	0	0	0
33				0	0	0	0	0	0
34				0	0	0	0	0	0
35				0	0	0	0	0	0
36				0	0	0	0	0	0
37				0	0	0	0	0	0
38				0	0	0	0	0	0
39				0	0	0	0	0	0
40				0	0	0	0	0	0
41				0	0	0	0	0	0
42				0	0	0	0	0	0
43				0	0	0	0	0	0
44				0	0	0	0	0	0
45				0	0	0	0	0	0
46				0	0	0	0	0	0
47				0	0	0	0	0	0
48				0	0	0	0	0	0
49				0	0	0	0	0	0
50				0	0	0	0	0	0
51				0	0	0	0	0	0
52				0	0	0	0	0	0
53				0	0	0	0	0	0
54				0	0	0	0	0	0
55				0	0	0	0	0	0
56				0	0	0	0	0	0
57				0	0	0	0	0	0
58				0	0	0	0	0	0
59				0	0	0	0	0	0
60				0	0	0	0	0	0
61				0	0	0	0	0	0
62				0	0	0	0	0	0
63				0	0	0	0	0	0
64				0	0	0	0	0	0
65				0	0	0	0	0	0
66				0	0	0	0	0	0
67				0	0	0	0	0	0
68				0	0	0	0	0	0
69				0	0	0	0	0	0
70				0	0	0	0	0	0
71				0	0	0	0	0	0
72				0	0	0	0	0	0
73				0	0	0	0	0	0
74				0	0	0	0	0	0
75				0	0	0	0	0	0
76				0	0	0	0	0	0
77				0	0	0	0	0	0
78				0	0	0	0	0	0
79				0	0	0	0	0	0
80				0	0	0	0	0	0
81				0	0	0	0	0	0
82				0	0	0	0	0	0
83				0	0	0	0	0	0
84				0	0	0	0	0	0
85				0	0	0	0	0	0
86				0	0	0	0	0	0
87				0	0	0	0	0	0
88				0	0	0	0	0	0
89				0	0	0	0	0	0
90				0	0	0	0	0	0
91				0	0	0	0	0	0
92				0	0	0	0	0	0
93				0	0	0	0	0	0
94				0	0	0	0	0	0
95				0	0	0	0	0	0
96				0	0	0	0	0	0
97				0	0	0	0	0	0
98				0	0	0	0	0	0
99				0	0	0	0	0	0
100				0	0	0	0	0	0
BANK ACCOUNT STATEMENT

Cell Formulas
Range	Formula
D2:I100	D2	=IF($B2=D$1,COUNTIF($B$2:$B2,$B2),0)

Cells with Data Validation
Cell	Allow	Criteria
B2:B100	List	=ΕΠΙΛΟΓΕΣ

Hi,

I am using excel to manage the income and outcome payments of a small building with total 6 apartments.

In tab BANK ACCOUNT STATEMENT, I enter manually selecting from a list all income and outcome payments.

Then, from there, income payment with date and amount is also enter using formulas in the correct APT tab, APT 01, 02, 11, 12, 13, 14. In attached fie you can see it in APT 01.

Desired output is to combine tab APT 01 and APT 01_2. In tab APT 01, I need dates of amount due to be typed in column A and automatically change to the real date when payment was made. For example, if due date is 5/6/2020 and there is a payment according to BANK STATEMENT ACCOUNT Tab, on 8/5/2020, then date 5/6/2020 should change to 8/5/2020 without affecting other dates. Also, payment amount in column D should be in same row with payment date.

In addition, in Tab APT 01, column E, I need to have display the amount due like APT01_2 tab because I use formula in G column to know any moment in E24 how much an apartment due or has prepaid. Tab 01_2 only for explanation.