If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
Register for a FREE account, and/ or Log in to avoid these ads!
Is it possible to incorporate a formula that ill leave cells bank rather than prodive the DIV/O result? when copynig a formula into cells below Thanks
Try: =IF(P2="","",DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2))) or =IFERROR(DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)),"")
Forum Rules
Bookmarks