Thread: daily rate monthly sums

I need some help.

I pay a daily rate to providers and need to figure out how keep track of the monthly sum. See attached file or use example below.

2A daily rate $100.00
2B start date 1/15/2010
2C end date 4/2/10

In my spread sheet I want to figure out the total I spent for January then February, then March etc.

Sometimes though I do not have an end date so if there is no end date I would like the user to enter a search date 1A 4/30/20/10 and calculate the monthly sum based off that date.

Any help would be deeply appreciated, I think I over sold my skills to my boss.Attachment 70156

Try again to attach your file.