Tickler for Excel

murrey · Apr 20th, 2002, 06:17 PM

I have a caseload of 120 families. Once I meet with a family in our Head Start program, I have to revisit that family in 45 days. Is there some way that I can be reminded in 45 days that I have to call that family?
Thanks
Murrey

Mark W. · Apr 20th, 2002, 06:19 PM

=If(('Last Date'+45)>=TODAY(),"Time to call","")

[ This Message was edited by: Mark W. on 2002-04-20 17:43 ]

murrey · Apr 20th, 2002, 06:46 PM

Mark W.
Thank you. Thank you. Thank you.

kinkyparamour · Apr 20th, 2002, 08:53 PM

Mark,

I am not questioning your formula, I am just trying to learn from you. I type the formula as it appears using >= and I get the wrong answer. If I type the formula using <= I get the right answer. Just so I can see what is happening I subtract a3 (which is today()) from a1 (which is my starting date. Thinking this should be my total number of days from the start date I would exspect to see "Time to Call" when this number is 45 or higher. Instead I see the message with less them 45. Please explane what I am doing wrong.

Thank you for shareing and helping me and others to learn.....

Denny

Aladin Akyurek · Apr 21st, 2002, 02:26 AM

If the tickler must go in effect on the 45th day, use:

=IF(A1+45=TODAY(),"Time To Call","")

If the tickler must go in effect from the 45th day on, use:

=IF(TODAY()-A1>=45,"Time To Call","")

where A1 houses the date of the last meeting.

Addendum: You could also use hiliting family names thru conditional formatting, based on the dates of last meetings.

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-04-21 01:29 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 06:17 PM	#1
murrey New Member Join Date: Apr 2002 Posts: 15	I have a caseload of 120 families. Once I meet with a family in our Head Start program, I have to revisit that family in 45 days. Is there some way that I can be reminded in 45 days that I have to call that family? Thanks Murrey

Apr 20th, 2002, 06:19 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=If(('Last Date'+45)>=TODAY(),"Time to call","") [ This Message was edited by: Mark W. on 2002-04-20 17:43 ]

Apr 20th, 2002, 06:46 PM	#3
murrey New Member Join Date: Apr 2002 Posts: 15	Mark W. Thank you. Thank you. Thank you.

Apr 20th, 2002, 08:53 PM	#4
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Mark, I am not questioning your formula, I am just trying to learn from you. I type the formula as it appears using >= and I get the wrong answer. If I type the formula using <= I get the right answer. Just so I can see what is happening I subtract a3 (which is today()) from a1 (which is my starting date. Thinking this should be my total number of days from the start date I would exspect to see "Time to Call" when this number is 45 or higher. Instead I see the message with less them 45. Please explane what I am doing wrong. Thank you for shareing and helping me and others to learn..... Denny

Apr 21st, 2002, 02:26 AM	#5
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	If the tickler must go in effect on the 45th day, use: =IF(A1+45=TODAY(),"Time To Call","") If the tickler must go in effect from the 45th day on, use: =IF(TODAY()-A1>=45,"Time To Call","") where A1 houses the date of the last meeting. Addendum: You could also use hiliting family names thru conditional formatting, based on the dates of last meetings. Aladin [ This Message was edited by: Aladin Akyurek on 2002-04-21 01:29 ]