ok on pc not ok excel

  mrh 16:11 11 Jun 04
Locked

read earlier related threads - still not grasped !!
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
thanks in advance
mrh

  bremner 16:13 11 Jun 04

You will have to explain or post link to previous thread

  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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…