Excel Forumla

  • Thread starter Thread starter Rod. S
  • Start date Start date
R

Rod. S

I am hoping that you may be able to help me.



I have been able to work out a formula that will count down the day
from when an employee attended his/ her biennial assessment.



How can I get excel to either print a report or alert me, say, xx day
before employees are due for there next biennial assessment
 
One way:

Assume last biennial assessment in A1. Then number of days til next one
is:

=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) - TODAY()


Format as General.
 
And to alert you:

=IF((DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) - TODAY())<=30,"Within 30
days","")
 
Hi Rod...........

Assuming date of last biennial assessment is in A1,
=(TEXT(A1,"mmmm")&" "&TEXT(A1,"dd")&", "&TEXT(A1,"yyyy")+2)-TODAY()&" Days
until next biennial assessment"

Vaya con Dios,
Chuck, CABGx3
 
Back
Top