Sound like you want the NUMBER of months, not the month digit. "m" is for dates, you are asking for a number (I think).On 2002-05-01 11:38, minnie wrote:
=IF(D25>240,240,0)
How do I format the cell so that it comes up with 240? I currently have it formatted as Custom, m and t comes up with 8 instead of 240. 240 represents months.
Cell D25 has the following formula:
=DATEDIF(D22,D23,"M")
On 2002-05-01 11:38, minnie wrote:
=IF(D25>240,240,0)
How do I format the cell so that it comes up with 240? I currently have it formatted as Custom, m and t comes up with 8 instead of 240. 240 represents months.
Cell D25 has the following formula:
=DATEDIF(D22,D23,"M")