-
formula for dates
i have a question for a data sheet with completion dates i want to create a formula to count the lines marked completed with a date.. im using count if but is not working i was able to count the entries when no date available bu using ,"") at the end of the count if after my selection if any one can help me out with the…
-
Date calculation
How do I create a cell formula that calculates a future date from another cell that has a date?
-
Changing a Date (mm/dd/yyyy) to Month Year (January 2019)
I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE". Any suggestions? =IFERROR(IF(MONTH(@{Quality Database Range 1}@row) = 1, "January ", IF(MONTH(@{Quality Database Range 1}@row) = 2, "February ", IF(MONTH(@{Quality Database Range 1}@row) = 3, "March…
-
VLOOKUP not allowing me to return value from beyond Column #20
Hello - I'm using VLOOKUP to return values from two separate data sets based on a unique identifier for my projects. For one of the VLOOKUPs, the column_num (column that I want to return the value from) is column 27. Why is it that VLOOKUP will return any value from columns 20 and below only?
-
Help with Flag formula
I've tried a few different formulas using IF and ISBLANK but can't seem to figure this out, even after looking at a few post on here. Hoping you can help. I need help with creating a formula for the following: If a task is incomplete and the due date is in the past, a red flag will appear BUT if the 'due date' cell is…
-
Count "Yes" and Return Percentage?
I am trying to create a "scorecard" of sorts. I have seen the formulas that allow you to count the number of "Yes" and return a value. But can you return that value as a percentage of responses? For example, say I have 5 columns with drop down answers of "Yes" or "No". Assume four columns were "Yes" and 1 was "No"; That…
-
Using COUNTIFS with multiple conditions
Trying get a count of issues in a catergory sheet that is referenced from a main sheet and then add another condition to count the categories of only the ones where the site is checked. The first COUNTIFS works, but not the 2nd one like below . =COUNTIFS({Day 1 Support Log Range 1}, =[Issue Category]1, {Day 1 Support Log…
-
Networkdays and #invalid data error
Hoping you can help with the below formula. I need to return zero and can not get the iferror formula to work. current formula is =NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4). Screenshot included for reference. Thanks, Heather
-
If Statement Comparing Date of Text Entry Between Columns
We work from a running tracker were there are a series of dates (entered as text, not an actual date) are entered into different columns to signify when certain steps have been completed. I am trying to find a way to automate a flag or alert or something to designate how many days go between each step so we can easily see…
-
Count and compare date columns in 'form' based worksheet
I would like to know how I can count number of activities (rows) which are completed ('finish' date column) at or before 'planned finish' date. In the same formula it should only be counted when 'complete' column is ticked off and empty cells should not be counted. Note that this is a 'form based' worksheet, meaning rows…