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 .