OT: Excel Help

Ragnarok · #1 August 27th, 2004, 06:48 PM

I am having trouble getting it set up. I may not understand fully how I need to set up my cells to get it to work correctly.

Say I have cell A1 with just the text "Check out" and then cell B1 with the text "Check in."

Next I have cell A2 with a date of 6/30/2004 and cell B2 with a date of 2/15/2005. where would I put the formula?

geoschmo · #2 August 27th, 2004, 07:23 PM

Wherever you'd want to put it that isn't going to have some other data. The most likely spot would be C2.

And the formula would be

=IF(B2="",IF(TODAY()-A2>180,"yes","no"),"no")

Or are you wanting it to list the actual number of months instead of yes or no that it's over 6 months?

Ragnarok · #3 August 30th, 2004, 04:25 PM

Thanks Geo! That seemed to do the trick. I had to toy around with it a bit just to understand what it was doing but your formula worked.