DarkoDeign2
Board Regular
- Joined
- Jun 20, 2023
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Hi,
I have been searching the web for a workable formula, but so far I haven't been able to find anything to make use of.
Cell AE2 can be blank, or contain one of three possible words: "Apple", "Car" or "Book".
In cell AG2 I would like to have a formula that returns "todays date" if cell AE2 contains the word "Apple". Furthermore I would like to have the date static, so it doesn't change over time.
Would appreciate if somebody could help me figuring this out.
I have been searching the web for a workable formula, but so far I haven't been able to find anything to make use of.
Cell AE2 can be blank, or contain one of three possible words: "Apple", "Car" or "Book".
In cell AG2 I would like to have a formula that returns "todays date" if cell AE2 contains the word "Apple". Furthermore I would like to have the date static, so it doesn't change over time.
Would appreciate if somebody could help me figuring this out.
