Date Calculation

  • Thread starter Thread starter Eva Shanley
  • Start date Start date
E

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.
 
Eva Shanley said:
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.
Click to expand...

Hi Eva,

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

2rrs
 
Back
Top