Date based on a range that contains pm or am

Sharon Castiglia

Fixed but now getting an #invalid argument set. The formula used in the date column is taking values from a text/number column. Could that have something to do with it?

Paul Newcome

Ok. What columns are filled out manually/by the form?

Sharon Castiglia

The tech arrival time & Store Open time are filled out by the installing technician

Paul Newcome

What about [Install Date] and [Install End Date]?

Sharon Castiglia

Well I got something that worked.

=IF([Tech Arrived AM/PM]1 = [Store Open AM/PM]1, [Install Date]@row, IF(AND([Tech Arrived AM/PM]1 = "A", [Store Open AM/PM]1 = "P"), [Install Date]1, [Install Date]1 + 1))

Covers all the bases:

A to A install date, A to P Install date, P to P Install Date, P to A Install Date + 1

I think I have all the bases covered. If there were a way to give you 100 stars I would.🏆️👏

With many, many thanks

Sharon Castiglia

Paul Newcome

Happy to help. 👍️