Formula to give 0 if no value in corresponding cell

[Ecel Dumbo]

Hello

please find attached file. I have a cell which has a date formula. Now i need to adjust this formula in such a way that this cell will display no date if there is no value in corresponding cell

Please help

 

[Nebu]

=IF(B2=0,0,DAY(DATE(YEAR(J$1),MONTH(J$1)+1,)))

copy down
Thanks

 

[Khalid NGO]

Hi,
I think you just need an IF statement:
=IF(B2<=0,0,DAY(DATE(YEAR(J$1),MONTH(J$1)+1,)))

Regards,

Edit:
Nebu you always there

 

[Khalid NGO]

And in case if you don't want to change your current formulas, you show "0" with the help of conditional formatting:

1) Select your range J2:O10
2) Conditional formatting
3) Formula
=B2=0

4) Format > Custom > "0"
5) ok

Note: it will only for display and will not change the values to zero.

Regards,

 

[Ecel Dumbo]

Perfect thanks guys

 

[Deepak]

No If .

=(B2>0)*DAY(DATE(YEAR(J$1),MONTH(J$1)+1,))