-
First Month's Date Range
Hello, I'm looking to get a response like this: 07/01/23 - 07/31/23. I want to get the previous month's range based on the values in the column (The previous month could potentially have entries dating 9/1/23-9/25/23, for example). I am referencing another sheet's column {REF DATE}. Dates range from 7/1/23 to 8/2/23 at…
-
NETWORKDAYS WITH AN IF??
Can anyone help with a formula to track the number of days between 2 separate columns with the IF of stopping the count once a date is populated in one of those columns?
-
'Most Common' Formula
Hello, I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria. Example: Build 30 - Success Build 31- Success Build 31 - Failure Build 32 - Success The Application…
-
Working Days across a Date range
Hello friends! I'm hoping to have a column which automatically populates the number of working days in a given period from a [Start Date] and [Number of Months] columns. e.g. Start Date = 3rd July 2023 Number of Months = 2 Result = 45 days 63 calendar days – 18 days skipped: 9 Saturdays, 9 Sundays Would anyone have a…
-
Auto Populate a date if another cell contains specific text
So I am sure this has been asked, but i cant seem to find anything on this topic. I am looking for a formula that will auto populate a cell with a date if another cell within that same sheet contains specific text. Example: If [Assignment]@row, HAS "Audit", then place a date in [Audit Due]@row Searching for Specific Text…
-
NETWORKDAYS
PROBLEM SOLVED THANK YOU
-
IF CONTAINS Help!
Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.…
-
How to return a MAX Value of "0" if Remaining # of Weeks is < 0
Hello Amazing Community, I'm trying to create a formula to Remaining Number of Weeks on a project. Start Date = 5/30/23 End Date = 6/15/23 Formula for Remaining # of Weeks (from today) =NETDAYS(TODAY(), [End Date]@row) / 7 = -2.9 **Problem is when End Date is in the past, and TODAY keeps changing, in which case, Remaining…
-
Countif specific type and year
=COUNTIFS(Type:Type, ="CTA New"), ([Date Submitted]:[Date Submitted], IFERROR(YEAR(@cell), 0) = 2022) I've been looking at examples of this question all day - but for some reason I can't make my formula work. The above formula is #Unparseable. I want to count the number of rows with "CTA New" Type and 2022 Date Submitted…
-
Total time-off days by year
I am having trouble creating a formula on my Staff Total Days Off sheet that pulls information from my Time-off Request Log sheet but for a specific year. Sheet 1: Time-off request sheet tracks each employee's approved time-off dates and days with an additional column for YEAR of request. Sheet 2: The Total Days Off sheet…
