I am trying to calculate lead times for orders coming from a specific vendor. In the sample provided I have entered a simple formula to calculate # of weeks between 2 dates but I want it to use another cell if a date is not available.
Essentially i want it to calculate # of weeks between column G & E, if E does not have a date use column J. If no dates leave blank
Forum.xlsx
=iferror(int((if(e2="",if(j2="",1/0,j2),e2)-g2)/7), "")
Last edited by daffodil11; 11-05-2013 at 11:46 AM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
=if(e2="",if(j2="","",iferror(int((j2-g2)/7), "")),iferror(int((e2-g2)/7), ""))
Both worked beautifully. Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks