Hi folks!
I am trying to make a cell appear as blank if another cell contains no data;
In cell K2 I will manually be entering dates
In cell M2 I entered =EDATE(K2,1) - This means that in cell M2 it will appear as the corresponding date of K2 but a month later (i.e K2 is 15/02/2019 M2 will automatically populate as 15/03/2019)
However if K2 is empty, M2 appears as 31/01/1900
I want this to be blank
I therefore (rather hopefully) tried in M2 =IF(ISBLANK(k2),"", (=EDATE(K2,1))
Can anyone make amends to that formula so that it works, or suggest an alternative method?
Many thanks,
Robbie
Bookmarks