Hello Excel Fam,
I am trying to get around this formula.
Idea:
If a cell is not empty then the expected result is the current month and year.
Example:
When there is a date (or not empty cell) in column B then results should be current month and year column E. As shown below in red.
I have tried the following formula among others:
=IF(B2<>"","mm/yy")
=IF(C2<>"",MONTH(YEAR(TODAY())))
But the results I'm getting are 1/12 & 1/7, not even close to the correct results. Can someone shed some light?
Thanks in advance!
I am trying to get around this formula.
Idea:
If a cell is not empty then the expected result is the current month and year.
Example:
When there is a date (or not empty cell) in column B then results should be current month and year column E. As shown below in red.
I have tried the following formula among others:
=IF(B2<>"","mm/yy")
=IF(C2<>"",MONTH(YEAR(TODAY())))
But the results I'm getting are 1/12 & 1/7, not even close to the correct results. Can someone shed some light?
Thanks in advance!
A | B | C | D | E |
---|---|---|---|---|
Paid | 7/31/2020 | 9/19/2020 | Yes | 8/20 |
Paid | 8/31/2020 | 10/20/2020 | Yes | 9/20 |
Paid | 9/30/2020 | 11/19/2020 | Yes | 10/20 |
Pending | 10/30/2020 | Yes | 11/20 |