Automatic alerts in excel
 

I am trying to create a data base for training. I would like to place a date
for which some one attended a course in cell C3 and then when a refresher is
required the date of for which the qualfication is due to expire will appear
in cell F3. however I would like the cell to remain blac until 3 months
before it is due.

E.G.
Cell C3 contains 25 March 07 and the qualification required a yearley
refresher. Therefore in December 07 I would like the date 25 March 08 to
appear reminding me a refresher course is due.

When the date passes if the due date passes I would then like the words
OVERDUE to appear.

I did get some usefull advice however I cant seem to get it to work.
Thank you

Automatic alerts in excel
 

how about in B1 is the current date, C3 is the date the course was taken and
in F3 is a reminder that you want to show about a year later if C3 and B1 are
3 months or more apart. Put the dates in B1, C3 and the formula in F3 of
=if(b1-c3<90,"",c3+365)
issues - may be a Sat or Sun , this does not capture leap year, and 90 days
may be different than 3 month?
short cut though

good luck

"PK" wrote:

I am trying to create a data base for training. I would like to place a date
for which some one attended a course in cell C3 and then when a refresher is
required the date of for which the qualfication is due to expire will appear
in cell F3. however I would like the cell to remain blac until 3 months
before it is due.

E.G.
Cell C3 contains 25 March 07 and the qualification required a yearley
refresher. Therefore in December 07 I would like the date 25 March 08 to
appear reminding me a refresher course is due.

When the date passes if the due date passes I would then like the words
OVERDUE to appear.

I did get some usefull advice however I cant seem to get it to work.
Thank you

Automatic alerts in excel
 

Thanks for that however all I keep getting is "TRUE" any ideas what im doing
wrong.
--
pk


"Don" wrote:

how about in B1 is the current date, C3 is the date the course was taken and
in F3 is a reminder that you want to show about a year later if C3 and B1 are
3 months or more apart. Put the dates in B1, C3 and the formula in F3 of
=if(b1-c3<90,"",c3+365)
issues - may be a Sat or Sun , this does not capture leap year, and 90 days
may be different than 3 month?
short cut though

good luck

"PK" wrote:

I am trying to create a data base for training. I would like to place a date
for which some one attended a course in cell C3 and then when a refresher is
required the date of for which the qualfication is due to expire will appear
in cell F3. however I would like the cell to remain blac until 3 months
before it is due.

E.G.
Cell C3 contains 25 March 07 and the qualification required a yearley
refresher. Therefore in December 07 I would like the date 25 March 08 to
appear reminding me a refresher course is due.

When the date passes if the due date passes I would then like the words
OVERDUE to appear.

I did get some usefull advice however I cant seem to get it to work.
Thank you

Automatic alerts in excel
 

the TRUE says to me the formula has something wrong, check to make sure you
have comma's and double quotes right

"PK" wrote:

Thanks for that however all I keep getting is "TRUE" any ideas what im doing
wrong.
--
pk


"Don" wrote:

how about in B1 is the current date, C3 is the date the course was taken and
in F3 is a reminder that you want to show about a year later if C3 and B1 are
3 months or more apart. Put the dates in B1, C3 and the formula in F3 of
=if(b1-c3<90,"",c3+365)
issues - may be a Sat or Sun , this does not capture leap year, and 90 days
may be different than 3 month?
short cut though

good luck

"PK" wrote:

I am trying to create a data base for training. I would like to place a date
for which some one attended a course in cell C3 and then when a refresher is
required the date of for which the qualfication is due to expire will appear
in cell F3. however I would like the cell to remain blac until 3 months
before it is due.

E.G.
Cell C3 contains 25 March 07 and the qualification required a yearley
refresher. Therefore in December 07 I would like the date 25 March 08 to
appear reminding me a refresher course is due.

When the date passes if the due date passes I would then like the words
OVERDUE to appear.

I did get some usefull advice however I cant seem to get it to work.
Thank you