I have tried a number of formulas in an effort to - enter a date in one column / row and have it calculate out 30 days and self populate a date in a different column / same row . This date column is already part of another calculation dependent on a completion date to give me how many days past due .
I have a check box which is formatted in to a cell to count how many projects are in sheet (Numaric) - Release date - which i need to auto fill the date due column - I have a start date that already is already formatted in to the project count to show how many projects are started (Numaric) - Due Date (Which i need to have auto filled 30 days from the release date) Column Date submitted are the drivers in the Days past due
Seems like it would be simple - like i'm missing something - put a date in one cell and have another cell display a date all in the same row - can any one give me a suggestion - might be over thinking here .
