wanted to use if function by comparing date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))>TODAY(),"After","Before")

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
separating date and time 5
convert 13.11.2009 general to 13/11/2009 date, how to 1
Complex date VBA - insert a certain weekday 5
IF and Date 6
Excel is seeing the date as dd/mm/yyyy 4
Working with Date/Time 1
Date format problems after csv import 2

Back
Top