Pro Rata Calculator in Excel

[DeLaMartre]

Could anyone recommend a clean approach to setting up a Pro Rata Calculator in Excel. I would like to have the user be able to enter two dates and the dollar amount, and have Excel calculate the resulting pro rata dollar amount.

Any help would be greatly appreciated.

Thanks very much,

-Bob in California

 

[SkipVought]

Hi, Bob in California,

Where is your formula? Don't you have anything designed yet?

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[DeLaMartre]

Hello Skip,

Thanks for the reply; When I recovered from my "senior moment", I realized it was a simple application of "YEARFRAC".

Sorry for the trouble.

Regards,

-Bob in California