Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DebCook

    #Value error message

    xlhelp, the 1st senerio worked perfectly! No need for add-in. When I grow up I wanna be smart like you guys! Skip: originally I started with Access. This database was awesome. Calculations of due dates, avg.wage, you name it it answered any & all questions that could possibly be asked...
  2. DebCook

    #Value error message

    Thank you everyone for you help constructing this workbook.
  3. DebCook

    #Value error message

    Column A: Contract #: =IF('F:\Workload Lists FY2010\[WIA DW Client Tracking FY2010.xlsx]Classroom'!B2="","",'F:\Workload Lists FY2010\[WIA DW Client Tracking FY2010.xlsx]Classroom'!B2) Column B: First Name: =IF('F:\Workload Lists FY2010\[WIA DW Client Tracking...
  4. DebCook

    #Value error message

    I copied the foumula that kjv posted above and that worked taking the #Value out, but now I need those cells to calculate 6 & 12 month due dates. Thanks!
  5. DebCook

    #Value error message

    here is a sample of what I'm work'n with? 6-Month Due Date & 12-Month Due Date hold the calculation from the Exit Date Contract # First Name Last Name Exit Date 6-Month Due Date 6-Month Sent Date 6-Month Return Date 12-Month Due Date 12-Month Sent Date 12-Month Return Date ARM-WIA/D-020-06...
  6. DebCook

    #Value error message

    That took out the #Value error, thanks! Where in this formula, do I put the d2+365 (d2 being the cell that holds the exit date from the original worksheet)to calculate the date for the year?
  7. DebCook

    #Value error message

    Thanks kjv1611 for your info, but how do I make this IF(IsError(...)...,...) work with all my workbook/worksheet madness? I don't know where or how to do it! Thanks!
  8. DebCook

    #Value error message

    =IF('[WIA DW Client Tracking FY2010.xlsx]Classroom'!M2="","",'[WIA DW Client Tracking FY2010.xlsx]Classroom'!M2) is the formula I used to collect my data into a follow-up workbook from mulitple Program workbooks. I need to calculate 6-months from the exit dates into column d2:d30. However, not...

Part and Inventory Search

Back
Top