| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i set a date reminder to check on something in a certain.
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i set a date reminder to check on something in a certain.
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 -- Allllen "vette" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check whether a date falls in a range | Excel Discussion (Misc queries) | |||
| how to check if date falls within range | Excel Worksheet Functions | |||
| how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
| Countif and date check for second criteria | Excel Worksheet Functions | |||
| Countif and date check for second criteria | Excel Worksheet Functions | |||
Linear Mode
