Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
This forums is so helpful. I've tried to find the answer in here to this question but it's giving me fits. Any help would be appreciated. I've got a cell that contains the current date (AA3). It's automatically populated using =TODAY() - I think that's right! Then I have a column that contains the last visited date which is entered manually. I have a column that I need to return to me Yes or No as to whether or not we need a follow up visit. I want it to automatically return Yes if the last visited date is equal to or greater than 6 months before Today's date. Thanks in advance. Christine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |