Forum Discussion
Solved
Today() or No Change if cell is already a date
COLUMN F G H I J K L M HEADING MATCH NO. DATE COMP. LEVEL PLAYER MATCH PTS PLAYER Pts COMPUTER Pts WINNER DATA 1 EXPERT Tom 5 7 2 Tom The above r...
- Works like a dream. I had already allowed iterations but, and it´s a HUGE but, having copied your formula into my spreadsheet, I made an error with the row number! What a dummy!
Thank you so much for your help - and patience! 👍☺
The formula will enter a date in G2 if you enter something in both K2 and L2 (and if you have enabled iterative calculation)
See the attached demo workbook.
Works like a dream. I had already allowed iterations but, and it´s a HUGE but, having copied your formula into my spreadsheet, I made an error with the row number! What a dummy!
Thank you so much for your help - and patience! 👍☺
Thank you so much for your help - and patience! 👍☺