PDA

View Full Version : differenec between two cells - tricky one



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

GTO
10-24-2008, 10:19 PM
Greetings Pete,

Case you're still looking for this, there was no attachment.

Mark

georgiboy
10-24-2008, 10:31 PM
You could try the days 360 function

=DAYS360(Milestone Detail & Matrix - Pre!B13,Milestone Detail & Matrix - Cur!B13)

Place this in your difference sheet

This function can be slightly inacurate due to the fact it assumes thereare 30 days in each month

or

just take one date away from the other

=Milestone Detail & Matrix - Cur!B13-Milestone Detail & Matrix - Pre!B13

so

lets just say the dates are on the same sheet to make it easier to read and you wanted the difference returned within a string within an if statement, it would be

=IF(B1>A1,"There is an increase of "&B1-A1&" days","Same")

B1 being the largest date

Hope this helps