Search results for query: *

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...

Thank you everyone for you help constructing this workbook.

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...

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!

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...

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?

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!

=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...