I need to calculate two formulas.

1. Need to create a formula for % time elapsed (based on 365 days)
2. Need to create a formula for % to Forecast vs time elapsed .

More information would be useful.

For 1, are you saying you have a start date, an end date, and a current date,
and you want to know what % of the period has elapsed from start to current? If
so, try:

=(current - start) / (end - start), format as percent.

For 2, you might be able to compare this calculated % with the forecast %. If
that's not what you are looking for, post back with more details.

--
Regards,
Fred


"sue" wrote in message
...
I need to calculate two formulas.

1. Need to create a formula for % time elapsed (based on 365 days)
2. Need to create a formula for % to Forecast vs time elapsed .

Let's say the spread sheet measures sales volume for 365 days (06 calendar
year). So, some of the columns on the page going across a

$ sales month to date; $ sales ytd; Forecasted volume; % to forecast ytd.

I think the formula is year to date $ sales / total forecast = % to yearly
forecast..

but we will be comparing that to total time elapsed for the year.. I don't
know how to do do it. This should be a running formula that "ticks" away
the year in %.. so we know how much time we have left to make the number vs %
to actual $'s achieved to date. Make sense?

"Fred Smith" wrote:

More information would be useful.

For 1, are you saying you have a start date, an end date, and a current date,
and you want to know what % of the period has elapsed from start to current? If
so, try:

=(current - start) / (end - start), format as percent.

For 2, you might be able to compare this calculated % with the forecast %. If
that's not what you are looking for, post back with more details.

--
Regards,
Fred


"sue" wrote in message
...
I need to calculate two formulas.

1. Need to create a formula for % time elapsed (based on 365 days)
2. Need to create a formula for % to Forecast vs time elapsed .

Make sense? No.

Try posting a specific example. I'm sure that will help us figure out what
you're trying to do.

--
Regards,
Fred


"sue" wrote in message
...
Let's say the spread sheet measures sales volume for 365 days (06 calendar
year). So, some of the columns on the page going across a

$ sales month to date; $ sales ytd; Forecasted volume; % to forecast ytd.

I think the formula is year to date $ sales / total forecast = % to yearly
forecast..

but we will be comparing that to total time elapsed for the year.. I don't
know how to do do it. This should be a running formula that "ticks" away
the year in %.. so we know how much time we have left to make the number vs %
to actual $'s achieved to date. Make sense?

"Fred Smith" wrote:

More information would be useful.

For 1, are you saying you have a start date, an end date, and a current date,
and you want to know what % of the period has elapsed from start to current?
If
so, try:

=(current - start) / (end - start), format as percent.

For 2, you might be able to compare this calculated % with the forecast %. If
that's not what you are looking for, post back with more details.

--
Regards,
Fred


"sue" wrote in message
...
I need to calculate two formulas.

1. Need to create a formula for % time elapsed (based on 365 days)
2. Need to create a formula for % to Forecast vs time elapsed .