This projects involve VFP createing a Excel spreadsheet to be sent to the client thereby allowing them to play what if which means the date range can change.
The issue is how to, within Excel, determine the number of monthis touched within a date range. The date range (full months as 1 day is charged for the whole month) plays a big part in the calculations. VFP calculates the total costs based on months touched by the date range before sending the spreadsheet to the client (that's the easy part). TIA George --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

