Posts by tradertt

Thanks guys. Will try that when I get back to work on monday. Great help

If it is not installed, any other ways to get this thing to work ? Any other forumulaes?

Will be trying it out today at work thank you. EDATE looks good

Thank you it works GREAT!

Can anyone help on this?

Quote

Originally posted by thomach
That precise question cameup on another thread today. Here is the link. I think the sample I posted there will answer your question.

http://www.ozgrid.com/forum/viewthread.php?tid=4819

If you need to "ROUND" to the nearest whole month, consider using the day function on each date and rounding up or down depending on whetherthe difference is greater than or less than say 15 days.

EDIT: Just noticed that the thread I referrenced was yours. Please do not post the same question in two places (start multiple duplicate threads) as this gets folks confused and scatters (rather than consolidates) information on common topics.

Display More

Thank you and sorry for the repost. Because I was looking thru the threads and saw the thing I needed so I thought I should post here to ask sorry about that.

Hi what if I do not want to take into account the number of days but only the number of months, becaus I found out that from
20/05/03
to
13/07/03

It is only considered as 1 mth in
DATEDIF(A1,B1,"m")

Is there anyway I can leave out the DATE part and enter only the month and the yr? Thank you.

Thank you for any help.