I have =IF(K4="","",(EDATE(K4,6))) to keep my cells blank untill I enter the start date, I now recently needed to add text along with the start date and cant have a seperate start date column because the file already has so much data were trying to make it smaller. Is there anyway to change the above formula to only recognize the date in the column? or maybe a different formula all together?
Bookmarks