User Profile
JenAllen932
Copper Contributor
Joined Aug 29, 2023
User Widgets
Recent Discussions
Excel formulas
I’m working on a formula and have to have to consider multiple situations. I need it to say if contract date minus app date Ab2-C is less than 90, leave the cell blank. If Ab2-C is equal to or greater than 90, then subtract 77 days from the contract date. Would prefer an output of a date for that column.395Views0likes0Comments- 996Views0likes0Comments
Formula issues if and
I’m trying to write an if and formula that considers 5 different cell values for my yes / no output. I have three of them handled, but am hung up on two of the others. My current formula says “=if(and(N2=“real”, o2=“conditional”, CP2=“”),”YES”,”NO”) I need to add Y2 is not blank and if R2 is within 16 days of todays date. Every time I try to do it, I mess up my output.Solved1.2KViews0likes6Comments- 1.2KViews0likes0Comments
Excel formula help
I am trying to find the best formula for the following situation. I want to take a date, subtract a certain number of days (will vary) and have the output only display Monday - Friday. If it lands on a Saturday or Sunday I want the date to default to the prior Friday. I’m currently using the workday formula but it’s counting business days. I want to count calendar days but not display weekends in my output. Example - date 9/6 minus 10 days - output would be 8/27 which is a Sunday so I would want it to display 8/25Solved1.4KViews0likes6Comments
Recent Blog Articles
No content to show