Sunshine8790
Board Regular
- Joined
- Jun 1, 2021
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
I have the following formula in Column L that I want to paste down thousands of rows of data, but there are rows in which there is no data in Column K.
How do I edit the formula to return the month if there is a date in Column K, but remain blank if there is no data?
How do I edit the formula to return the month if there is a date in Column K, but remain blank if there is no data?
Excel Formula:
=MONTH(K2)