Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic alerts in excell | Excel Discussion (Misc queries) | |||
How Excel VBA corporate with MSN Alerts? | Excel Discussion (Misc queries) | |||
How do I set up Alerts and Notification on Excel? | Excel Discussion (Misc queries) | |||
Settings for pop up alerts in excel | Excel Discussion (Misc queries) | |||
how do i set up sound alerts on excel? | Excel Discussion (Misc queries) |