Re: OT: Excel Help
Yes, it should be possible. Just to recap:
Check out Check in Greater then 6 months
6/24/03 1/28/04 yes
The above is the table you have. You want to automate the calculation of the third col to tell you if it has been greater then 6 months. I believe you can do this 1 of 2 ways. You can write a VB script through Excel's VB interface or use an IF statement for your formula. Try IF(DATE(A3,B3,120)>D3,"No","Yes") where cell A3 is the year and cell B3 is the month. If you need it down to the specific day look at the Day function.
Rasorow
|
Threaded Mode