between two dates

Hello, I have formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =(DATEDIF(start date column, TODAY(),"d")+1)/(DATEDIF(start date column, end date column, "d")+1). This has worked well...

Hi - I am checking if any projects at work fall between a change freeze - either their start or end date. There are a few scenarios - projects starting within the period and then going several months ahead, projects starting before and finishing during the project - but essentially each...

Hi :) I have a question concerning due dates and finished dates. How would I format the two columns to where if it is complete, the red format I have set up for "expiring soon" goes away? If the order is complete, I'd like for the conditional formatting to correspond. Due date is column D, and...

Hello Excel specialists, I got number of sheets. In one I have list of invoices and relevant information about them. Second sheet is clients information list and third is list with overdue payments. Below I added screenshots to better understand situation: Invoice List Example: Client List...

Hi all, i'm sure there is a simple way to do this but i'm not aware of it and after a quick look online i haven't found the answer yet, or if i did i didn't understand it so didn't realise it was what i needed! so the problem: i have a sheet where i want users to enter data, asset purchases...

Hello Again, I was looking for some help to determine if any of the dates listed cells A6 through A17 is equal to (A1); or if they fall between A1 and A2). Placing a result in A3. Example A1: Mar 15-13 A2: Mar 29-13 A3: "Yes" (result or "no" depending on result) A6: January-29-13 A7...

Hello, I am trying to establish a formula that will determine if the DAY value will fall between two dates. A1 = Start Date; B1 = March 28-13 cell formatted as date A2= End Date; B2 = April 8-13 cell formatted as date A3= DAY; B3 = 01 cell formatted as date but...

Description Quantity Start Date Finish Date Jan-10 Feb-10 1 2 3 4 1 2 3 4 Excavation 100 05-01-10 14-01-10 30 70 Hi friends, I am having an excel spreadsheet as shown above. I have splitted every month into 4 weeks.. 1 - 7 = First Week 8-14 = Second Week 15 - 21 = Third Week...