{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","ورقة2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ورقة1","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,6,8,6]]}
["التاريخ","عدد السنين"]
["2023-07-01",5,null,null,null,null,"السلام عليكم ورحمة الله وبركاته بعد اذنكم محتاج معادلة توزيع التواريخ بناء على الخلية A2 الخلية B2 المعادلة توزع التواريخ مثل النموذج الموجود في الخلية B5"]
[]
["م","توزيع التواريخ",null,"وهذا نموذج الحل"]
[{"$f":"IF(B5<>\"\",ROWS($B$1:B1),\"\")","v":1},{"$f":"A2","v":"2023-07-01"}]
[{"$f":"IF(B6<>\"\",ROWS($B$1:B2),\"\")","v":2},{"$f":"IF(ROW(B1)>=$B$2,\"\",EDATE($B$5,ROW(B1)*12))","v":"2024-07-01"}]
[{"$f":"IF(B7<>\"\",ROWS($B$1:B3),\"\")","v":3},{"$f":"IF(ROW(A2)>=$B$2,\"\",EDATE($B$5,ROW(A2)*12))","v":"2025-07-01"}]
[{"$f":"IF(B8<>\"\",ROWS($B$1:B4),\"\")","v":4},{"$f":"IF(ROW(B3)>=$B$2,\"\",EDATE($B$5,ROW(B3)*12))","v":"2026-07-01"}]
[{"$f":"IF(B9<>\"\",ROWS($B$1:B5),\"\")","v":5},{"$f":"IF(ROW(B4)>=$B$2,\"\",EDATE($B$5,ROW(B4)*12))","v":"2027-07-01"}]
[{"$f":"IF(B10<>\"\",ROWS($B$1:B6),\"\")","v":""},{"$f":"IF(ROW(B5)>=$B$2,\"\",EDATE($B$5,ROW(B5)*12))","v":""}]
[{"$f":"IF(B11<>\"\",ROWS($B$1:B7),\"\")","v":""},""]
[{"$f":"IF(B12<>\"\",ROWS($B$1:B8),\"\")","v":""},""]
[{"$f":"IF(B13<>\"\",ROWS($B$1:B9),\"\")","v":""},""]
[{"$f":"IF(B14<>\"\",ROWS($B$1:B10),\"\")","v":""},""]
[{"$f":"IF(B15<>\"\",ROWS($B$1:B11),\"\")","v":""},""]
[{"$f":"IF(B16<>\"\",ROWS($B$1:B12),\"\")","v":""},""]
[{"$f":"IF(B17<>\"\",ROWS($B$1:B13),\"\")","v":""},""]
[{"$f":"IF(B18<>\"\",ROWS($B$1:B14),\"\")","v":""},""]
[{"$f":"IF(B19<>\"\",ROWS($B$1:B15),\"\")","v":""},""]
[{"$f":"IF(B20<>\"\",ROWS($B$1:B16),\"\")","v":""},""]
[{"$f":"IF(B21<>\"\",ROWS($B$1:B17),\"\")","v":""},""]
[{"$f":"IF(B22<>\"\",ROWS($B$1:B18),\"\")","v":""},""]
[{"$f":"IF(B23<>\"\",ROWS($B$1:B19),\"\")","v":""},""]
[{"$f":"IF(B24<>\"\",ROWS($B$1:B20),\"\")","v":""},""]
[{"$f":"IF(B25<>\"\",ROWS($B$1:B21),\"\")","v":""},""]
[{"$f":"IF(B26<>\"\",ROWS($B$1:B22),\"\")","v":""},""]
[{"$f":"IF(B27<>\"\",ROWS($B$1:B23),\"\")","v":""},""]
[{"$f":"IF(B28<>\"\",ROWS($B$1:B24),\"\")","v":""},""]
[{"$f":"IF(B29<>\"\",ROWS($B$1:B25),\"\")","v":""},""]
[{"$f":"IF(B30<>\"\",ROWS($B$1:B26),\"\")","v":""},""]
[{"$f":"IF(B31<>\"\",ROWS($B$1:B27),\"\")","v":""},""]
[{"$f":"IF(B32<>\"\",ROWS($B$1:B28),\"\")","v":""},""]

{"sheet":"ورقة2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}