The Jackal
New Member
- Joined
- May 30, 2018
- Messages
- 13
Hi,
I am currently using =MONTH([@[Date Sold]]) in order to extract the number ascosiated with the Month. However, this displays "1" if the cell is blank. I would like it to be blank if there is no date.
I have tried adding =IF(ISBLANK but cant get this to work. Please help.
Carl
I am currently using =MONTH([@[Date Sold]]) in order to extract the number ascosiated with the Month. However, this displays "1" if the cell is blank. I would like it to be blank if there is no date.
I have tried adding =IF(ISBLANK but cant get this to work. Please help.
Carl