Hello,

I have a sales tracking sheet and it determines how many invoices will occur
in 2005 for an order. The problem I am having right now is counting the # of
monthly invoices that will occur. It seems simple, but its not working out
for me. Basically what my problem is for example March. if the order was
placed in March, there would be 10 invoices (one each for March through
December). However, if the order date becomes March 18th, it is only
reporting 9 months. I am using round function but to no avail. Any help is
appreciated. Below is my formula:

=IF(AND(N4="monthly",T438717),ROUND((38717-O4)/30.42,0),IF(AND(N4="monthly",T4<38717),ROUNDDOWN(( T4-O4)/30.42,0)

I'm sure there is a simple way. Thanks.

How about

=IF(N4="monthly",12-MONTH(T4)-(DAY(T4)17),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brad" wrote in message
...
Hello,

I have a sales tracking sheet and it determines how many invoices will
occur
in 2005 for an order. The problem I am having right now is counting the #
of
monthly invoices that will occur. It seems simple, but its not working out
for me. Basically what my problem is for example March. if the order was
placed in March, there would be 10 invoices (one each for March through
December). However, if the order date becomes March 18th, it is only
reporting 9 months. I am using round function but to no avail. Any help is
appreciated. Below is my formula:


=IF(AND(N4="monthly",T438717),ROUND((38717-O4)/30.42,0),IF(AND(N4="monthly"
,T4<38717),ROUNDDOWN((T4-O4)/30.42,0)

I'm sure there is a simple way. Thanks.

As a start maybe something like:
=if(And(N4="Monthly",Year(T4)=2005),If(day(O4)<=15 ,13-Month(O4),12-Month(O4)
),0)



--
Regards,
Tom Ogilvy

"Brad" wrote in message
...
Hello,

I have a sales tracking sheet and it determines how many invoices will
occur
in 2005 for an order. The problem I am having right now is counting the #
of
monthly invoices that will occur. It seems simple, but its not working out
for me. Basically what my problem is for example March. if the order was
placed in March, there would be 10 invoices (one each for March through
December). However, if the order date becomes March 18th, it is only
reporting 9 months. I am using round function but to no avail. Any help is
appreciated. Below is my formula:


=IF(AND(N4="monthly",T438717),ROUND((38717-O4)/30.42,0),IF(AND(N4="monthly"
,T4<38717),ROUNDDOWN((T4-O4)/30.42,0)

I'm sure there is a simple way. Thanks.