R
Renz09
I need I formula to calculate the number of days from one date to
another.
Example:
01-May-06 to 05-June-06 = 36 days
I've tried the 360 day function, but the problem being it calculates
based on 360 days not the number of days in each month. Each month is
either 28, 30,or 31 days in it. I need a formula that calculates on
the month not the day. Please somebody help me with this!!
another.
Example:
01-May-06 to 05-June-06 = 36 days
I've tried the 360 day function, but the problem being it calculates
based on 360 days not the number of days in each month. Each month is
either 28, 30,or 31 days in it. I need a formula that calculates on
the month not the day. Please somebody help me with this!!