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! 👍☺
Hi Hans. I´ve yet to try the code solution, but sad to say that you formula leaves G2 blank. Sorry!
I´ll try the VBA, tomorrow!
Thank you,
Tom
I´ll try the VBA, tomorrow!
Thank you,
Tom
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! 👍☺