Yup! that's exactly what I need, i have a busy day job and couldn't find the time to work this very basic thing out but now you put it like that (in the upload) it is so simple!!! perfect, thanks
Hi there,
I need a simple spreadsheet designed to help me work out different mark up percentages in order to set a final price points for goods that I sell. Column headings would be: item, unit price, markup, retail price, profit.
Please email back if you are interested in building this for me...
Hi there,
I am not the most experienced excel person, but I aim to be!
I work in procurement, we set up a supplier panel of 31 Energy providers and I need to display the information on our intranet in the form of a spreadsheet.
I have attached what our web girl has done, but I feel like there...
I work at MFAT (in the aid programme) im in procurement, we do a lot of benchmarking & analysis and I love excel but have never really taken the time to learn it, just use it on the fly.
Hey,
I'm using conditional formatting and I want the flag icons to replace the value so that im just left with a pictorial representation of my project status and not the conditional formatting coding that I created in behind it (if that makes sense).
Abby
Thanks for that, I checked it out it seems to be the one I need. So I only need to put in the holiday dates? and it automatically takes into account the weekend days right? just double checking...
Thank you for your quick response, I would like to exclude weekends and holidays and our weekends are sat / sun. I am using 2010 so I will check out the workday function that you have suggested. Thank you again!
Hello from NZ,
I am creating a project plan for a business unit, I have calculated the number of business days for each stage. The total number of business days for the whole project is 116. I want to be able to type in 1 October 2013 and excel automatically tell me what 116 business days is...