Lease Option Date
 

I have a lease option expiring say no earlier than 12 months nor later than 6
months from a lease expiration date. The formula needs to be smart enough to
work around 30 day months, 31 day months etc. Any ideas?

Lease Option Date
 

We have lots of ideas. What's the question? What do you want to calculate.
For best responses, show examples of what you need.

Regards,
Fred.

"JC PHX" <JC wrote in message
...
I have a lease option expiring say no earlier than 12 months nor later than
6
months from a lease expiration date. The formula needs to be smart enough
to
work around 30 day months, 31 day months etc. Any ideas?