Date Calculation

[Eva Shanley]

Hi,
I'm trying to calculate the difference between two dates
in months; the DATEDIF formula works fine. However, the
user wants the month calculation to change depending on
how many days into the month he is. A whole month does not
occur until the end of the month; he wants the whole month
to be counted from any date greater than the 14th of the
month. This would be the criteria for either the start
date or the end date or both. I've tried several formulas
with mild success which is getting me nowhere. Any
solutions would be wonderfully appreciated. Thanks.

 

[2rrs]

Hi,
I'm trying to calculate the difference between two dates
in months; the DATEDIF formula works fine. However, the
user wants the month calculation to change depending on
how many days into the month he is. A whole month does not
occur until the end of the month; he wants the whole month
to be counted from any date greater than the 14th of the
month. This would be the criteria for either the start
date or the end date or both. I've tried several formulas
with mild success which is getting me nowhere. Any
solutions would be wonderfully appreciated. Thanks.

Hi Eva,

try this:
=DATEDIF(A128,A129,"m")+(DATEDIF(A128,A129,"md")>=14)

2rrs