I searched the forums for EDATE but I didn't see anything that helped me, quite.
This is the current formula:
=IF(R2<20,"",IF(M2="Pre-QA",N2,IF(M2="Pending",N2,IF(U2=0,N2,O2))))
Where N2 and O2 are both dates.
I want the formula to change those to the end of the month for this cell but I can't figure out where to/how to put the EDATE bit in.
Help? Thanks!
Bookmarks