SAMPLE of Dates in database
A--------------------B--------------------C---------------------D
__________________________________________
---START-------END--------RESTART------------STATUS
1 02/02/02-------------------------------------------------Active
2 06/07/01----10/10/01---------------------------------Inactive
3 04/05/00----03/03/01----02/02/02----------------Active
__________________________________________
Need formula in STATUS column
(1)to interpret dates in relative row and
(2)to insert either "Active" or "Inactive" in STATUS cell.
Active = If START date is input
Inactive = if start date + END date are input
Active = if start date, end date, and RESTART date are input.
CONDITIONS:
All valid dates = earlier than the NOW date -- at least by =NOW() -1 day.
All valid dates = later than those in the preceding column.
Please notify if more info or an attachment is needed showing model.
This message was edited by KATHWUN on 2002-04-08 21:11
A--------------------B--------------------C---------------------D
__________________________________________
---START-------END--------RESTART------------STATUS
1 02/02/02-------------------------------------------------Active
2 06/07/01----10/10/01---------------------------------Inactive
3 04/05/00----03/03/01----02/02/02----------------Active
__________________________________________
Need formula in STATUS column
(1)to interpret dates in relative row and
(2)to insert either "Active" or "Inactive" in STATUS cell.
Active = If START date is input
Inactive = if start date + END date are input
Active = if start date, end date, and RESTART date are input.
CONDITIONS:
All valid dates = earlier than the NOW date -- at least by =NOW() -1 day.
All valid dates = later than those in the preceding column.
Please notify if more info or an attachment is needed showing model.
This message was edited by KATHWUN on 2002-04-08 21:11