Time/Date Stamp formulas
I am trying to auto populate a time date stamp when a cell is filled in on a row. Ex Submission Status
then I need to create a formula to populate a due date based on the time date stamp and based on Priority Levels
Priority Level (Business Days)
High - 3 days
Medium - 5 days
Low - 10 days
NBD<12pm- (Next Business Day before 12pm )
2BD>12pm - (2 Business days after 12pm.)
I have attached a copy of my sheet to give you and idea of what I am trying to do.
Any help is appreciated.
Help Article Resources
Check out the Formula Handbook template!