Hi All,
I am wanting a formula to work out costing for different dates. I have 4 costings lets say A and B both before a certain date and after, with A and B choosed by a drop down menu. I have a start date and a end date as well
So if it is before a certain date i need it to pick up how many mondays there are before that date and how many mondays after that date inbetween the start and end dates and assign either A or B costing depending of the drop down.
Would this be able to be done or not.
Thanks in advance for any help you might be able to give me.
Donald
Bookmarks