Jul 07 2022 02:23 PM
I can't figure the formula to calculate the date of the day when data is entered in adjacent cell. Need help!!
Jul 07 2022 02:51 PM
This requires VBA code or a formula that uses iterative calculation (circular references).
If you want to try the latter, do the following first.
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.