formula and dates

Hi, I creating a permit register. End Goal : Have the text in both Cells in "Start Date" and "Finish Date" have the same colour to determine if the Permit is 'Expired', 'Current' or set in the 'future' Column H (Permit Start Date) and Column I (Permit Finish Date). Permit dates do not have...

So I have run into a scenario that I have never had. I have a formula, which I have used before but on a lesser population of data, and it has been working fine. However, I now have a much larger volume of data I need to run it on. When I run the formula, after about 5 minutes, it comes back...

Is there way to combine this IF formula: =IF(OR(ISBLANK(I2),ISBLANK(A2)), "",) with this DAYS formula: =DAYS(I2,A2) into 1 cell. What i am trying to accomplish is calculate the number of days left for a certain date but if the date (cell I2) is not entered yet I want the count down cell to...

So I have a sheet where I have some dates and some results, I am trying to combine a few different formulas into a single one so that I don't have to look at several columns to get my results. When I have the formulas separated, it works fine, but when I try to combine them, I don't get the...

I have a spreadsheet which has due date in column AB, and a completed date in column AC. If today's date is = to AB and AC is blank, I'd like AC to turn orange. If today's date is +1 day greater than AB and AC is blank, I'd like AC to turn red. If a date is entered in AC which is either equal...

Hi, Can someone help with this one? Based on an initial date, need to calculate 3 years later end of year. Example: Expiration date is the last day of the third succeeding calendar year Initial date: 19/09/2018 End date: 31/12/2021 Thanks! Helena

Greetings to Tech Gurus, I'm seeking help in nesting a formula but ending up with an error. Please see below details for my formula nesting. C3= % (this cell will have number up to 100 in %) F3= Date (this cell will have date in MM/DD/YYYY format) G3= formula (below is the formula which i'm...

Apologize in advance if my request seems confusing. I need a formula that indicates the "end date" of when I run out of the content pieces on column F. This is based on the "start date" and the fact that these pieces are distributed only on Monday and Tuesday. I would appreciate it if...

Hi. I've never used Excel to calculate dates before. I have a basic grasp of some date related functions but not enough to be able to solve the following problem. I'm hoping someone with more knowledge than I have will be able give me some help. Basically, I need to display the next (date)...

I need to conditional format cells where a date is less than today but no longer than 6 days ago. In conditional formatting, what formula do I use to achieve this?

Hi guys I need to calculate the difference between two dates (Days/Months/Years) all in one cell, I tried the formula as shown in the screenshot, but it faild. I have microsoft office excel 2007 I tried every trick I found on youtube, but none of them worked It would be very helpful if you...

So please be kind, I am a rookie and don't understand a lot of the language people use when responding to my questions. 1. I have a spreadsheet and I DON'T want to reconfigure the whole thing so I am hoping to get an answer to what I hope is a simple question. 2. I am using a customer format...

Can someone help me with a formula to sum integer values stored in cells in a single row, based on the current date. In row 1, starting in column B, there are 12 cells containing dates April through March. B1:M1 In row 26, starting in column B, there are 12 cells that contain integer values...

Hi, I'm not good at complex formulas. I want to calculate the difference between two dates in hh:mm format excluding weekands and Holidays range. Tried Networkdays.Intl but not avail so far. Input format: <tbody> Start Date End Date <colgroup><col width="165"></colgroup><tbody> May...

HI there, Can someone help, i have a problem where i have the 4 columns consisting of an Estimated Start Date (C19) and End date(D19) and Actual Start Date(F19) and End date(G19) for different project functions. I am sorted for the the start of point here i have in Cell J16 =DAY(F19+1) which i...

I've been having a hard time finding a solution for this problem I'm having. On Column A is a name of an edit to a certain set of drawings. The drawings are on Row 3, starting at Column E (ie: E4) and the symbols found on row 4 signify which of the drawing sets have the latest revision...

Hello, I'm after a formula that will return the financial year/calendar year and quarter from a date field Date Calendar Year Calendar Year 01/01/2016 to 30/03/2016 1st Qtr 2016 3rd Qtr 2015/2016 01/04/2016 to 30/06/2016 2nd Qtr 2016...

I want the help in one of my excel dashboards where i need the automation. I have attached 3 document as per the below:- 1.My Dashboard data 2.Amit_Team Data 3.Harshad_Rec data I want the button to be set into my dashboard data file and do the following:- 1.It should open the Amit_Team Data...

Is there a way to return Month/Year from a cell that contains Week/Year? Example: A1 contains "03/2016" and would like to show "January/2016" or "01/2016"

Hello, I have a table with historical purchase history (i.e. prices paid for various products over time). Then I have another table, the "product request table", where I need to use a formula to pull in the most recent price paid for a product as of a certain date (not including purchases made...