Use the MIN and MAX functions...

=MAX(--"6/30/2008",A1)

=MIN(--"7/1/2009",A1)

--
Rick (MVP - Excel)


"lemonscented" wrote in message
...
I would like to calculate the fractions of various grants that can be spent
this fiscal year. Some of the projects start this year, some started
before
this year, other projects end this year, some projects continue after this
year, and others both start and end this year.

I have figured out how to calculate the total months in the grant using
DATEDIF. However, I don't know how to calculate the number of months for
this year.

To calculate the months for this fiscal year, I could also use DATEDIF.
The
first date would be either June 30, 2008 or the project start date
depending
on which is later. Likewise, the second date would be July 1, 2009 or the
project end date, whichever is earlier. How would the formula
automatically
select the correct dates?

Do I seem to be on the right track?