formulas with dates

Help please. I need a formula that will add 15% to a date. If the resulting date is a Saturday, the date needs to be moved back to Friday. If the resulting date is a Sunday, the date needs to move up to Monday. Here's what I'm using now: - B5 is a start date - B6 is an end date - B7 calculates...

I am needing to have one cell of a column to turn red when one or more of the dates in this particular column is 3 weeks before the date in the specific cells of this column. Help

Hi I'm trying to build a spreadsheet that will be able to calculate current stock levels by taking into account what the last action was (e.g. stocktake, purchase, order), etc but I don't know how to write formulas that will do what I need them to do. Any data from before the stocktake...

Hello! Thank you for looking this over. I appreciate it. I have a large number of files in the following format: 943291169-20100419_201417. That is, unimportantnumbers-date_time. I'd like to pull the date and time out of that name without having to go through the files one at a time and place...

I have a report I am working on and my focus in on three columns. One with Commitment Dates, the next column is the 2012 Status, and the third column is the 2013 Status. I need to create a formula that looks at the Commitment Date and returns either "Committed" or "Non-Committed". Obviously...