ExcelBanter - Date functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date functions (https://www.excelbanter.com/excel-worksheet-functions/143124-date-functions.html)

Dianethetech

Date functions

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A227,B2,C1)

--
DMM

Mike

Date functions

Check your other post

"Dianethetech" wrote:

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A227,B2,C1)

--
DMM

Dianethetech

Date functions

Sorry Mike, this is my first time trying to use this and I can't find my
other posting.
--
DMM

"Mike" wrote:

Check your other post

"Dianethetech" wrote:

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A227,B2,C1)

--
DMM

Teethless mama

Date functions

Try this:

=IF(DAY(A2)27,B2,C1)

"Dianethetech" wrote:

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A227,B2,C1)

--
DMM

Dianethetech

Date functions

Thanks, that works great.
--
DMM

"Teethless mama" wrote:

Try this:

=IF(DAY(A2)27,B2,C1)

"Dianethetech" wrote:

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A227,B2,C1)

--
DMM

All times are GMT +1. The time now is 01:17 AM.