bigcahoonerburger
New Member
- Joined
- Oct 20, 2002
- Messages
- 7
Can anyone provide me with a formula that looks in a cell containing a date(B12) and returns one value if the date contains Jan or Jun , and another value if it doesn't?I have tried using the IF function but as the date in B12 can change, the corresponding value won't .Hope this makes sense