I wrote a quick import formula (=A2)+2 to pull in the date from A2 and add 2 days. If there is a date present it works fine. If A2 happens to be empty or blank it returns 1/2. Apparently if a cell is blank and formatted for dates (mm/dd) it has a value of 1/0 because something like 4/6 will return 4/8. How can I keep this from happening? Both columns are formatted for dates, and I have special formatting on worksheet to replace all zeros in cells with blank cell.
A/2: blank
S/2: =(A2)+2
A format for dates
S format for dates
worksheet formatted to show blank cells for zero cells
S2: populates 1/2
A3: "4/7" (april seven)
S3: =(A2)+2
A format for dates
S format for dates
worksheet formatted to show blank cells for zero cells
S2: populates "4/9"
I want S2 to populate nothing. Can I use IF or SUMIF?
Any help is greatly appreciated
Bookmarks