| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date: Auto text entry based on aging
L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven days
older than the date I've manually entered in B3, then M17 should read "Update Needed"; if within seven days from B3, it should read, "Current". I am unable to get my formulas to work. Are there any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto text entry based on aging
Enter the following formula in cell M17
=IF(L17-B3=7,"Update Needed","Current") "Annabelle" wrote in message ... L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven days older than the date I've manually entered in B3, then M17 should read "Update Needed"; if within seven days from B3, it should read, "Current". I am unable to get my formulas to work. Are there any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto text entry based on aging
Sorry I got it the wrong way round, it should be as this
=IF(B3-L17=7,"Update Needed","Current") "Howard31" wrote in message ... Enter the following formula in cell M17 =IF(L17-B3=7,"Update Needed","Current") "Annabelle" wrote in message ... L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven days older than the date I've manually entered in B3, then M17 should read "Update Needed"; if within seven days from B3, it should read, "Current". I am unable to get my formulas to work. Are there any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to auto-populate worksheet based on cell entry? | Excel Discussion (Misc queries) | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| auto population based on single cell entry | Excel Discussion (Misc queries) | |||
| Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
| auto entry of a date | Excel Worksheet Functions | |||
Linear Mode
