-
Calculating Next Monday, Wednesday, Friday
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([Start Date]@row, 2)), "") using the example above; however, it generated an #INCORRECT ARGUMENT error. The expected results…
-
IFERROR and january dates for previous month (and Year)
Happy New Year All. I have successfully had help in navigating the problems of "Previus" month when a new year like now for both COUNTIFS and SUMIFS However, I have a simple IF statement and just cannot get it to work. 4 fields Date & Time - this is the automated date creation value This Month - dropdown with True or False…
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
-
Is there a way that I can have a return date once something is "APPROVED"?
Hello! I'm trying to have a cell populate with the date that "APPROVED" is clicked. Ex: If "DC Ha Review" has "APPROVED" chosen in the dropdown, I wanted the Approval Date column to populate with that date. So, as I've chosen "APPROVED" in that column, the Approval Date column would have today's date. Any help would be…
-
Index Collect with a Date Range Criterion
I am trying to utilize an index collect formula that will cross-reference another sheet. Some of the reference criteria are numbers but two criteria need to narrow the options to a specific date range (i.e. >= DATE1 and < =DATE2). These columns are in date format. The data I am trying to bring back into the cell is a name…
-
Copy Row Reminder to Another, or All, Rows
In a project with multiple date columns that function as due dates, you can set up row reminders that correspond to those due date columns. This is in addition to setting up Automated Workflows that can email reminders on due dates. But why would you want to set up row reminders in addition to using the Automation…
-
% complete using a duration of dates
I am trying to get a percent complete using dates. For example, I have a start date and a finish date to get the duration (let's say that is 96 days) and I want to find out the percent complete using today's date (automatically updated each day) as the task progresses in time. I can't seem to figure out how to use TODAY()…
-
Convert Quarters to Date
I have a list of dates that are Quarter/year (in a format like Q4 2031, Q1 2038, etc.) and would like to use a formula to show the last date in the quarter. So: Q1 2031 = 03/31/2031 Q2 2027 = 06/30/2027 Q3 2033 = 09/30/2033 Q4 2035 = 12/31/2035 I would appreciate help creating the appropriate statement!
-
Merged: Linked Non-Working (Holiday) List
This discussion has been merged.
