Ask Your Question

Revision history [back]

In my testing this code works with the spreadsheet I reverse-engineered although I can't make promises it'll work later:

=IF(
    MONTH(C2)==MONTH(O2);

    TEXT(
        NOW();
        "mmmm"
    ) & "/" & TEXT(
        NOW()+O2;
        "mmmm"
    );

    1
)

No newlines:

=IF(MONTH(C2)==MONTH(O2); TEXT(NOW(); "mmmm") & "/" & TEXT(NOW()+O2; "mmmm"); 1)

The file: This and next month in a cell with overlapping days, rautamiekka 0.ods