ExcelBanter - wanted to use if function by comparing date

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

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

- - wanted to use if function by comparing date (https://www.excelbanter.com/excel-worksheet-functions/148332-wanted-use-if-function-comparing-date.html)

Alok Rai

wanted to use if function by comparing date

I am using if formula and wanted to use date as criteria

for eg.

Cell A Cell B

30/01/2006 =if(cell A.............., x,y)
dd/mm/yyyy

I want to use a date in place of ................... Kindly Suggest

Mike H

wanted to use if function by comparing date

Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))TODAY(),"Afte r","Before")

Mike

"Alok Rai" wrote:

I am using if formula and wanted to use date as criteria

for eg.

Cell A Cell B

30/01/2006 =if(cell A.............., x,y)
dd/mm/yyyy

I want to use a date in place of ................... Kindly Suggest

Alok Rai[_2_]

wanted to use if function by comparing date

Thanks,

i got the solution

"Mike H" wrote:

Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))TODAY(),"Afte r","Before")

Mike

"Alok Rai" wrote:

I am using if formula and wanted to use date as criteria

for eg.

Cell A Cell B

30/01/2006 =if(cell A.............., x,y)
dd/mm/yyyy

I want to use a date in place of ................... Kindly Suggest

Teethless mama

wanted to use if function by comparing date

Shorter version

=IF(A1TODAY(),"After","Before")

"Mike H" wrote:

Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))TODAY(),"Afte r","Before")

Mike

"Alok Rai" wrote:

I am using if formula and wanted to use date as criteria

for eg.

Cell A Cell B

30/01/2006 =if(cell A.............., x,y)
dd/mm/yyyy

I want to use a date in place of ................... Kindly Suggest

All times are GMT +1. The time now is 02:22 PM.