how can i set a date reminder to check on something in a certain.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vette - 07 Nov 2006 16:01 GMT

I need to create a spreadsheet that can allow me to input a date and set a
reminder for me to check on the account in a certain amount of days. I need
to know how to do this if at all possible. I am pretty sure that this can be
done i just don't remember how to. if you can help me that would be greatly
appreciated.

Reply to this Message

Allllen - 07 Nov 2006 16:56 GMT

Cell A1 contents: (the date when you need to check)
Cell A2 contents: =today()
Cell A3 contents: =if(A2=>A1,"reminder to check account","")

then you can also start to play with format > conditional formatting

Signature

Allllen

> I need to create a spreadsheet that can allow me to input a date and set a
> reminder for me to check on the account in a certain amount of days. I need
> to know how to do this if at all possible. I am pretty sure that this can be
> done i just don't remember how to. if you can help me that would be greatly
> appreciated.

Reply to this Message