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
Bookmarks