date function contingent of data in adjacent cell

Occasional Visitor

I can't figure the formula to calculate the date of the day when data is entered in adjacent cell. Need help!!

1 Reply

@toddmartin65 

This requires VBA code or a formula that uses iterative calculation (circular references).

If you want to try the latter, do the following first.

  • Select File > Options.
  • Select Formulas.
  • Tick the check box 'Enable iterative calculation'.
  • Click OK.

Let's say you want to enter data in A2 and down.

Enter the following formula in B2:

=IF(A2<>"",IF(B2="",TODAY(),B2),"")

Format B2 as a date.

The formula can be filled down if desired.