Hi folks,
I have a an issue where I need to populated fields based upon meeting date criteria. The attached should explain, if not please let me know...
Thanks,
Brad
Populate cell based upon date compare
-
- 4StarLounger
- Posts: 545
- Joined: 30 Mar 2010, 18:49
- Location: United States
Populate cell based upon date compare
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Populate cell based upon date compare
Does this formula in F6 do what you want? It can be copied to the right.
=IF(OR($C6>F$5,$D6<F$5),"",$E6)
=IF(OR($C6>F$5,$D6<F$5),"",$E6)
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 545
- Joined: 30 Mar 2010, 18:49
- Location: United States
Re: Populate cell based upon date compare
Absolutly!
Rock on
Brad
Rock on
Brad