-
IF AND formulas
I wonder if anyone would be able to help me. I am trying to collate some data that allows me to give a count of a number of jobs that have missed a target date. The sheet I am working on also has 2 different cost centres and I would like to break this data down so that I can see the data for each cost centre. I have…
-
today plus x networkingdays
how do i build a formula that gives me the actual date for today + 35 working days?
-
Networkday
Hello all - first time poster I am trying to get the difference between two dates by using the NETWORKDAY formula and I am having an issue. I have 2 date field columns - an assignment date and a go-live date - and I am trying to find the difference in business days between the two. I have successfully run the formula to…
-
Nested If Statements
I'm trying to check a box to indicate whether a remediation item has been opened or closed in the past year. My relevant fields are report date, target date, and date closed. Date Closed could potentially be blank. Here is the formula I've been trying to refine: =IF(OR(TODAY() - [Report Date]77 < 365, TODAY() - [Last Remed…
-
Nested Formula
I’m new to posting in the Community. I have looked through previous posts but cannot find anything similar to what I am trying to do. I am trying to nest a LOOKUP formula. My current (working) formula is: =LOOKUP("In Progress", [Progress Should Be]74:[Unit Number]154, 4, true) There are three possible values in the…
-
If Today is Greater Than
Hello, I have these columns on a sheet: Expected Return Date (date) Actual Return Date (date) Media Manager (contact) How do I send an email to the Media Manager if the Expected Return Date has passed? "If today is greater than Expected Return Date and Actual Return Date is blank, send notification to Media Manager"…
-
Count values that are not formatted with Strikethrough
Hello - - I am trying to count the number rows in a column that do not have strikethrough applied to them. Is there anyway to use a formula to determine if a cell value has been formatted with strikethrough? Thanks,
-
Importing Spreadsheets with Vlookup from Excel
Is it possible to import a spreadsheet (with a few sheets in it) which has Vlookup and other formulas? Doesnt anyone has done it? I have just signed in for a free trial... it looks like I have to do all the hard work again in terms of formulas (in special Vlookup)... if so, see little benefit in using this. regards, Jandir
-
Payroll Breakup
Hello, I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time period. I am having a hard time coming up with an equation for each pay-period cell. Pay, 1/15, 1/31, 2/15....
-
Formula to calculate the amount of time between two dates
I'm trying to use the below formula to calculate the amount of days between when a project is due, and when it was actually finished. Sometimes this will be earlier than the due date, sometimes after. =NETWORKDAYS([Delivery Date]98, [Power Approval]98) When the dates are the same, I'd expect the result of zero. But it…