Forum Discussion
date function contingent of data in adjacent cell
I can't figure the formula to calculate the date of the day when data is entered in adjacent cell. Need help!!
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.
