Results 1 to 6 of 6

Return EDATE with an IF statement...? [SOLVED]

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Phoenix, AZ, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Return EDATE with an IF statement...? [SOLVED]

    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!
    Last edited by mirage1; 01-21-2013 at 02:17 PM. Reason: All resolved, thanks!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1