trouble with dates

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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

bigcahoonerburger

New Member
Joined
Oct 20, 2002
Messages
7
Sorry but his formula only returns yes or no ,not changing as the corresponding date in b12 does.The date in b12 is the sum of 2 other cells if this makes any difference
 
L

Legacy 11779

Guest
You will have to explain further with some examples of what is in B12 and what results you want from the formula.
 

Forum statistics

Threads
1,143,640
Messages
5,719,984
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top