Time to call

murrey · Apr 24th, 2002, 01:15 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

you said use: =If(('Last Date'+45)>=TODAY(),"Time to go","")

How do I put it in the cells to make it work? Thanks.

Mark W. · Apr 24th, 2002, 01:19 PM

murrey, I goofed (and, was corrected by my colleagues). The comparison operator should have been <= instead of >=. I apologize if my error inconvenienced you.

You can replace 'Last Date' with a cell reference as in...

=IF((A1+45)<=TODAY(),"Time to go","")

...Or, you can subsitute your own single quoted column header inplace of 'Last Date' if you've checked the "Accept labels in formulas" option on the Calculation tab obtained via the Tools | Options... menu command.

[ This Message was edited by: Mark W. on 2002-04-24 12:36 ]

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

Apr 24th, 2002, 01:15 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 you said use: =If(('Last Date'+45)>=TODAY(),"Time to go","") How do I put it in the cells to make it work? Thanks.

Apr 24th, 2002, 01:19 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	murrey, I goofed (and, was corrected by my colleagues). The comparison operator should have been <= instead of >=. I apologize if my error inconvenienced you. You can replace 'Last Date' with a cell reference as in... =IF((A1+45)<=TODAY(),"Time to go","") ...Or, you can subsitute your own single quoted column header inplace of 'Last Date' if you've checked the "Accept labels in formulas" option on the Calculation tab obtained via the Tools \| Options... menu command. [ This Message was edited by: Mark W. on 2002-04-24 12:36 ]