Dear All, I need to do profit and loss analysis through excel presentation for different project for month, problem is our client billing cycles are different to different to all the projects, example: AOC (project) billing cycle every month 15th to next month 14th for NCR every month 24th to next month 25th, where is my all projects expenditure comes under every month 1st working day to month last working day. hence i am not able to calculate profit and loss analysis, is there any way in excel to do these analysis.
sample sheet attached Please suggest and help me . Thanks in advance. Regards, Krish. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
PROFIT AND LOSS ANALYSIS SAMPLE SHEET.xls
Description: MS-Excel spreadsheet
