Blank Cell if no date

[The Jackal]

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

 

[awoohaw]

try

=IF([@[Date Sold]]="","",MONTH([@[Date Sold]])

mr excel questions 17.xlsm
	A	B	C	D	E
1		DateSold	Amount	Month
2		2023-01-18	24	1
3		2023-03-19	21	3
4		2023-02-23	22	2
5		2023-02-16	39	2
6			34
7		2023-03-18	36	3
8		2023-02-21	31	2
9		2023-01-25	36	1
10		2023-01-22	45	1
11		2023-01-10	34	1
12
The Jackal

Cell Formulas
Range	Formula
D2:D11	D2	=IF([@DateSold]="","",MONTH([@DateSold]))

 

[The Jackal]

Thats working fine and i have tried to do the same for an adjacenbt cell with =WEEKNUM([@[Date Sold]],2) but yet again my lack of knowledge fails me.

=IF([@DateSold]="","",WEEKNUM([@DateSold]],2)) wont do the same????

 

[awoohaw]

Thats working fine and i have tried to do the same for an adjacenbt cell with =WEEKNUM([@[Date Sold]],2) but yet again my lack of knowledge fails me.

=IF([@DateSold]="","",WEEKNUM([@DateSold]],2)) wont do the same????

you're missing a bracket, formula should be:

=IF([@DateSold]="","",WEEKNUM([@[DateSold]],2))

The formula dialog is helpful in debugging!

 

[The Jackal]

Its always the backets lol

Thank you.