# ok on pc not ok excel

mrh 16:11 11 Jun 04
Locked

need formula - small graph- appraisals.
1st column 'last appraisal'in date form- 2nd column 'appraisal due' graph to show percentage of appraisals completed - all for only a dozen people
any help would be great
mrh

bremner 16:13 11 Jun 04

VoG II 16:20 11 Jun 04

?

mrh 16:27 11 Jun 04

apologies have read earlier responses to similar questions - but not managed to resolve my own dilema - as stated earlier - i am trying to get excel formula in date format - adding/subtracted date formula - if in date on appraisal to say so, if out of date to say so, i then hope to show information from worksheet onto graph.

stlucia 16:33 11 Jun 04

=IF((A1-B1>0)," ","overdue") would do what you want, I think.

VoG II 16:37 11 Jun 04

Or

=IF(DATEDIF(B2,TODAY(),"d")>0,1,0)

A result of 1 indicates appraisal due, 0 = not due.

mrh 16:38 11 Jun 04

will try that now - thank you for such a quick response
mrh

mrh 16:52 11 Jun 04

all ok but have made a error on formula in 2nd column for next appraisal due - there annual
mrh

VoG II 16:55 11 Jun 04

trying to be too clever and it doesn't work as intended.

With last appraisal date in B2, format C2 as Date and enter the following formula

=B2+365

In D2 enter the formula

=IF(TODAY()>C2,1,0)

I'm assuming names go in column A.

Select C2 and D2, hover cursor over the bottom right of D2 until the cursor turns into a +

Hold down left mouse button to copy the formulas down as far as needed.

VoG II 16:56 11 Jun 04

Above assumes annual appraisals (365 days).

mrh 16:59 11 Jun 04

after such a speedy reply - pushing my luck - what would your formulae be for 2nd column
in hope mrh

This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

How to get WWDC 2017 tickets