Sign in to join the conversation:
I have a formula that calculates the number of days and would like to add the word "days" at the end of the formula. In Excel, I would use '& "days"' as in =NETDAYS(Added1, Closed1)&" days" ...
Use the plus sign
=NETDAYS(Added1,Closed1) + " days"
Craig
Exactly what I was trying to do. Thanks!
This helped me out too, thanks!
I have a column that displays the date from a reference in another sheet. However there is a different column on that the source sheet where a date can be entered and it should display that date if entered. I tried to error trap for blanks but I am still getting #DATE EXPECTED. Here is the formula for context.…
Hi all, I'm building out a month-end checklist for a department and they want to be reminded on Day 1 of every month to start their tasks and on Day 10 to complete their tasks. I was able to create a simple workflow that on Day 1 and Day 10 of every month, it sends them a reminder, however, they have asked if day 1 or 10…
I need to pull the Form ID (and other columns) from Sheet B into Sheet A. These conditions all need to be met: Departure Date ⇒ Date Field 1 Departure Date =< Date Field 2 Destination (Sheet B) contains City (Sheet A) Name (Sheet B) contains Last Name (Sheet A) This is the current formula I have: =INDEX(COLLECT({Form ID},…
