I am trying to find a formula for the following:
If cell A1 has a date in it, copy that date to cell F1. If A1 does not have a date in it, copy the date from cell B1 into cell F1.
I have a receipt tracking form that sends data to a spreadsheet. The form will use the current date every time I make an entry. That's great if I pull my phone out right then and there and enter the receipts values. That obviously doesn't always happen. I might end up waiting till Friday evening to enter them all for the week. So I also included a date entry on the form so that I can enter the actual date of the transaction.
I would like a formula that will allow me to choose, if there is a manual date entered into the form and that date goes to cell B1, then use that date and ignore the date that is in cell A1.