[Johnny T]

If you will: I have a billing sheet that we use for quarterly billing; some
accounts are billed for a full quarter and some for partial, depending on
date of account inception. Does anyone have a suggestion for a formula that
will look at the account inception date and calculate the number of days that
should be billed (using an end date that, for sake of expedience) we will
input into the sheet every quarter. The formula should be inclusive of the
inception date but not inclusive of the billing date.

Thanks--I know this is a newbie question--I need some guidance from someone
more experienced to ensure I get this right.

[Ted Zieglar]

Are we supposed to guess what program you are using?

If it's Excel, post in a newsgroup for Excel, like this one:
news://microsoft.public.excel.newusers

--
Ted Zieglar
"You can do it if you try."

"Johnny T" <JohnnyT@discussions.microsoft.com> wrote in message
news:C53AD1AA-FAAD-4F8D-AD43-8295F7D32067@microsoft.com...
> If you will: I have a billing sheet that we use for quarterly billing;
some
> accounts are billed for a full quarter and some for partial, depending on
> date of account inception. Does anyone have a suggestion for a formula
that
> will look at the account inception date and calculate the number of days
that
> should be billed (using an end date that, for sake of expedience) we will
> input into the sheet every quarter. The formula should be inclusive of
the
> inception date but not inclusive of the billing date.
>
> Thanks--I know this is a newbie question--I need some guidance from
someone
> more experienced to ensure I get this right.