Hi
I've tried searching for this answer on the Internet but I just cannot get my head around some formulas and wondering if someone has a simple solution for the below:
I have a column that I type a date into, I then want the adjacent column to add two months to the date. This works fine on cells that I want to type into, but the blank cells that I leave (to add to later) are making the formula cell have a default date displayed. I want the +2 month column to ignore any blank cells and only display the +2 month date should a date be entered.
Hopefully someone can help and I hope the above makes sense.
I did try creating an IF formula, but it said A1 expects a boolean but cell A1 contains a date.
Many thanks
Bookmarks