Trying to build a model with dates as inputs.

[misterv]

Is there a simple way to build a model with dates as inputs? Based on those dates, it would make calculations/pro rata calcuations from a set of data that has month end number only?

[Pete_UK]

I think you will need to be a bit more specific than that, and explain more clearly what data you have and what you want the "model" to achieve.

Pete

[misterv]

Thanks, I just joined. Hopefully I can post a pic soon.

[Pete_UK]

A picture is not much use to us in helping you - It would be better if you attached a sample Excel workbook instead, and you can do this even if you have only just joined.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon for attachments, as it doesn't work on this forum.

Hope this helps.

Pete