Pete
10-23-2008, 02:02 AM
See attached workbook
Hi Experts
How would i insert into a difference description bewteen worksheet(s) "Milestone Detail & Matrix - Pre" and "Milestone Detail & Matrix - Cur" in the attached workbook. Range B13:BE56 both worksheets
So say if we had a difference of dates bewteen as follows:
worksheet "Milestone Detail & Matrix - Pre" cell B13 date = 25 September 08
and
worksheet "Milestone Detail & Matrix - Cur" cell B13 date = 29 September 08
So in worksheet "Difference" the basic if forumla will say difference and highlight cell B13 as Red in font black text to make the user aware of the difference.
But i would also like the difference of 25/09/08 - 29/09/08 i.e. +4 days movement in date to be shown in cell b13 worksheet "Difference Description"...
I hope this make some sense
Hi Experts
How would i insert into a difference description bewteen worksheet(s) "Milestone Detail & Matrix - Pre" and "Milestone Detail & Matrix - Cur" in the attached workbook. Range B13:BE56 both worksheets
So say if we had a difference of dates bewteen as follows:
worksheet "Milestone Detail & Matrix - Pre" cell B13 date = 25 September 08
and
worksheet "Milestone Detail & Matrix - Cur" cell B13 date = 29 September 08
So in worksheet "Difference" the basic if forumla will say difference and highlight cell B13 as Red in font black text to make the user aware of the difference.
But i would also like the difference of 25/09/08 - 29/09/08 i.e. +4 days movement in date to be shown in cell b13 worksheet "Difference Description"...
I hope this make some sense