LinkBack URL
About LinkBacks
clanham 
Or
In C3 put this formula
=IF(B3="","",EDATE(B3,-2))
and pull it down for rows below it.
I see that is the formula that Melvinrobb did.
Great minds think alike?? Melvin is similar to Marvin?
Or
In C3 put this formula
=IF(B3="","",EDATE(B3,-2))
and pull it down for rows below it.
I see that is the formula that Melvinrobb did.
Great minds think alike?? Melvin is similar to Marvin?
Last edited by MarvinP; 08-28-2012 at 11:27 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I guess so.
The #1 reason I chose "IF" instead of "IFERROR" is in case the file needs to be used in 2003. The IFERROR function is much cleaner though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks