dates in formula

Hello, I need help on finding the best way to analyze when a vendor is delayed on providing services. I have worked on this for the past 2 days with AND and IF formulas but cannot get anywhere. Here is an example. I have couple items delayed and 1 in progress (3rd line). Thanks in advance! My...

I have a master list of SKUs in one table set as a column with a different SKU listed in each row. I have another table with a daily snapshot of items which I have in stock between 7/1/17 and 7/31/17 in each row. The table shows the item SKU in one column, the warehouse where there is...

Hi, I have 4 columns, as you can see below (Excel) <colgroup><col><col><col><col></colgroup><tbody> CustomerID TransactionDate Amount Date of 1st purchase 19 19/12/2016 131.5 19/12/2016 1465 24/12/2016 73.44 24/12/2016 2389 25/12/2016 49 25/12/2016 367 26/12/2016 25.9 26/12/2016...

Hello, My Question is need to display a text value "Started" & "Completed" cell a1 has start date Cell B1 has End Date display c1 "Started" or "Completed" based on the a1 and b1 dates.. a1 = 10th may (10-05-17) b1= 20th may(20-05-17) I have one more cell also , total number of...

Hi Team, I have a workbook that I am trying to create and an overall Dashboard to give a snapshot of information from my main list of projects. On the main sheet we enter details about the project, unique reference numbers, and dates to show start & end of projects. There are also sections...

Hi everyone, Happy Monday to you all. I need to build on the formulas that were created last week for counting visit statuses per location (with many thanks to you for help!) - Now the need is to count the number of visits that fall within a date range for each unique location. For example...

Hi All, I hoping someone may be able to help. I'm creating a purchase ledger and would like to include at the top all a total of: Total Unpaid Payments that are now overdue Payments that fall within 30 days Payments that fall within 14 days Payments that fall within 7 days Below I have tried...

I have an array formula below that adds transactions for each week. This works OK until I come to a week1 which starts on 30 December 2013 and ends 5 January 2014. My work sheets spans more than 1 year, 2013-2015. The answer that I get takes only the transactions in 2014 ie week 1, 1-5...

Hello, I have a situation where I have to schedule Dr. appointments on every Tuesday and Thursday of each month. There are 2 offices that get scheduled (room 101 and room 505). We can only schedule 1 appointment per day per office. I have 2 columns that have the Tuesday and Thursday dates...

=IF(OR(C111="YES",D111=""),"YES","") Hi all i am trying to create a formula that will return the word "YES" if criteria is met in cells C111 and D111 C111 either has YES or NO filled in the cells, while D111 has different dates, with some cells blank. I am struggling with cell D111 as i dont...

Hello friends i have a date in a cell say for example 06/09/2014 (due date) i have another date in a cell below for example 18/07/2015 (date of payment) in the cell below i have calculated the delay beetween two dates which is 315 days--- Now i would like to split these 315 days as- no.of...

Hi, I'm trying to get excel to run a macro that sends me an email when certain cells reach specific dates (current date and one week prior to current date). I've tried following the steps on Send a mail when a cell reaches a certain value but it doesn't work. I need excel to send me an email...

Can someone please help me figure out a formula to index a specific batch# from an array which is based on matching an amount, a sponsor code, and a date that may be greater than or equal to the specified date? Example (2 worksheets in the workbook): Worksheet 1 - "Batches Ran" Column A - Date...

Hi, I'm working on a spread sheet that I'm getting stumped on. In cell B2 I have the formula =Today() (which as I'm sure you know, picks up the current days date). The format is DD/MM/YYYY. If this date is between 01/MM/YYYY and 08/MM/YYYY then I want it to display 6.25 If this date is...

I have a fairly easy question seeking an elegant solution that exceeds my excel knowledge. I have the date of birth of a number of students. I want to know the students that are born in either September, October, November, or December. I also want to know if the students born in those months...

I have long table which looks like this: <tbody> A B C D 1 Date Order no. Value State 2 3 </tbody> When I need to get a subtotal of the values state-wise I use the array forumula: ={Sum(if(D2:D200="Name of State",C2:C200,0))} Now, when I use the same formula for a month-wise...