I am creating a formula to capture a rate per day * number of days of the month, but when it is a full month not to apply the formula
I mean if it is 28 Feb or 30 or 31 not to calculate the rate per day into Number of days, but to use the amount as is.
C13 Number of days of the month (fraction of the month) ; formula of CONCATENATE(DAY(E7)," days"
I used below formula
the result is always full amount
and it is not working when it is Feb 28 days?
How to make the "EOMonth" changeable based on the month in E7 date, then how to make the calculation correct, either full amount on full month or pro-rated by number of days
Appreciate your help