DATE DISPLAY FORMULA

[Bumblebee]

Need some more technical assistance, i have a date in a cell, but i would like a formula, so that if a certain date shows, then that cell will display blank, but only a specific date being 31/03/1900, if any other date is there, then it must display

 

[JawaharPrem]

Hi,

can you share the file.

 

[Bumblebee]

Excel sheet uploaded, focus on column K, it shifts the date 3 months ahead of column J, but if there no info in J then it displays as 31/03/1900, but i dont want it to show anything if it that date

 

[vletm]

JawaharPrem
for [K17] =IF(J17<>"",EDATE(J17,3),"")

 

[Bumblebee]

YOU ARE AMAZING, THANK YOU!!!!!!!!!

 

[JawaharPrem]

Great.. it works...