# Thread: Formula that counts down for a period of 24 months (2007)

1. ## Formula that counts down for a period of 24 months (2007)

Hi
I am attempting to create a training matrix that will allow me to enter each persons induction straight into the calendar with a built in timer that shows yellow for 3 weeks before renewal - orange for 2 weeks before renewal & red for 1 week before renewal. This also needs to count down for a period of 24 months as most inductions require renewal after this period.

I have attached my spread sheet to show you what I am trying to accomplish. I am still learning about excel and pretty much a beginner. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

2. ## Re: Formula that counts down for a period of 24 months (2007)

Good morning

I asked a similar questions starting here <post#=743,542>post 743,542</post#>, perhaps my result will help you

Cheers

Steve

3. ## Re: Formula that counts down for a period of 24 months (2007)

Thank you Steve I will try it - I never thought formula's were this hard. Its like trying to read Egyptian!!! I spend half my time googling the meanings of the terminology. <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

4. ## Re: Formula that counts down for a period of 24 months (2007)

Hi Again

Perhaps this example workbook with explanations may help you out

Cheers

Steve

5. ## Re: Formula that counts down for a period of 24 months (2007)

Thank you Steve
The help sheet is awesome - I will let you know how I do - thanks again. Celene

6. ## Re: Formula that counts down for a period of 24 months (2007)

Your welcome and its all due to the help of the people on this forum

Cheers

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•