IF worksheet function
 

I don't know if this possible, but looking for some help if it is. I am
guessing it would be with some sort of IF worksheet function.

I have a column of dates. In a separate cell a few columns to the right I
would like to enter a value (32.50) if the first of the month is among the
original column of dates; if not I would like to enter 0. I am guessing the
formula might look something like this:
=IF(11-01-06 is within the range D5:D18,32.50,0)

Again, any help with this would be appreciated, thank you.

IF worksheet function
 

Hi!

Try this:

=IF(COUNTIF(D5:D18,"2006/11/1"),32.5,0)

Do want this specifically for Nov 1 2006 or do you want it for the CURRENT
month? If so:

=IF(COUNTIF(D5:D18,DATE(YEAR(TODAY()),MONTH(TODAY( )),1)),32.5,0)

Biff

"WOLLAM" wrote in message
...
I don't know if this possible, but looking for some help if it is. I am
guessing it would be with some sort of IF worksheet function.

I have a column of dates. In a separate cell a few columns to the right I
would like to enter a value (32.50) if the first of the month is among the
original column of dates; if not I would like to enter 0. I am guessing
the
formula might look something like this:
=IF(11-01-06 is within the range D5:D18,32.50,0)

Again, any help with this would be appreciated, thank you.

IF worksheet function
 

Biff,
Awesome! Thank you very much; it worked like a charm.

"Biff" wrote:

Hi!

Try this:

=IF(COUNTIF(D5:D18,"2006/11/1"),32.5,0)

Do want this specifically for Nov 1 2006 or do you want it for the CURRENT
month? If so:

=IF(COUNTIF(D5:D18,DATE(YEAR(TODAY()),MONTH(TODAY( )),1)),32.5,0)

Biff

"WOLLAM" wrote in message
...
I don't know if this possible, but looking for some help if it is. I am
guessing it would be with some sort of IF worksheet function.

I have a column of dates. In a separate cell a few columns to the right I
would like to enter a value (32.50) if the first of the month is among the
original column of dates; if not I would like to enter 0. I am guessing
the
formula might look something like this:
=IF(11-01-06 is within the range D5:D18,32.50,0)

Again, any help with this would be appreciated, thank you.

IF worksheet function
 

You're welcome. Thanks for the feedback!

Biff

"WOLLAM" wrote in message
...
Biff,
Awesome! Thank you very much; it worked like a charm.

"Biff" wrote:

Hi!

Try this:

=IF(COUNTIF(D5:D18,"2006/11/1"),32.5,0)

Do want this specifically for Nov 1 2006 or do you want it for the
CURRENT
month? If so:

=IF(COUNTIF(D5:D18,DATE(YEAR(TODAY()),MONTH(TODAY( )),1)),32.5,0)

Biff

"WOLLAM" wrote in message
...
I don't know if this possible, but looking for some help if it is. I am
guessing it would be with some sort of IF worksheet function.

I have a column of dates. In a separate cell a few columns to the
right I
would like to enter a value (32.50) if the first of the month is among
the
original column of dates; if not I would like to enter 0. I am
guessing
the
formula might look something like this:
=IF(11-01-06 is within the range D5:D18,32.50,0)

Again, any help with this would be appreciated, thank you.