Re: OT: Excel Help
I would say the easiest way to do it is with a nested IF formula. The exact formula would depend on how you figure the 6 month interval. If you go with 180 days = 6 months, the formula is pretty simple:
=IF(B3="",IF(TODAY()-A3>180,"yes","no"),"no")
where colum B is your Checkout dates and Column A is your CheckIn dates
If you want to use 6 months on the Calendar regardless of number of days, it gets more complicated. It can still be done with one nested IF formula, but you'd need three IF's instead of two because you use the difference in months if todays day of the month is greater then the check out day of the month, and if it's not greater, you use the difference in months - 1. I can work that up tonight and post it if you'd like.
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|