-1

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.

|improve this question
  • 1
    Welcome. Are you familiar with ISDATE? Returns true for a date and false if not a date. Combine that with an IF and you're there. – Tedinoz Dec 8 '19 at 11:56
  • Please add a example of your attempts to create the formula. – Rubén Dec 8 '19 at 15:13
  • @Tedinoz I think the problem with the question is he starts off with "if cell A1 has a date in it" but when you read to the bottom of the question it looks like he doesn't care if it is a date and just wants to have an override column. – CodeCamper Dec 8 '19 at 18:44
1

Make sure to first delete excess rows before using arrayformulas... for example if you have 100 rows of data make sure you don't have more than 200 rows in your speadsheet... (highlight right click and delete excess rows) The following formula will do what you are asking for assuming row 1 is headers.

Paste the following in cell F1

=arrayformula({"Final Date";if(B2:B="",A2:A,B2:B)})
|improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.