PC Review


Reply
Thread Tools Rate Thread

Compare two dates

 
 
Dave
Guest
Posts: n/a
 
      18th Nov 2009
Hi,. I would like to compare two dates in the same row and return a true or
false statement.

How do I do this?
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      18th Nov 2009
Could you please elaborate your query. Do you mean?

With dates in A1 and B1

=IF(A1=B1,"dates are same","dates are not the same")

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

> Hi,. I would like to compare two dates in the same row and return a true or
> false statement.
>
> How do I do this?

 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      18th Nov 2009
=A1=B1
--
David Biddulph

"Dave" <(E-Mail Removed)> wrote in message
news:3847A239-1FAB-40E6-AA34-(E-Mail Removed)...
> Hi,. I would like to compare two dates in the same row and return a true
> or
> false statement.
>
> How do I do this?



 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      18th Nov 2009
Thats great thanks. So simple!

"David Biddulph" wrote:

> =A1=B1
> --
> David Biddulph
>
> "Dave" <(E-Mail Removed)> wrote in message
> news:3847A239-1FAB-40E6-AA34-(E-Mail Removed)...
> > Hi,. I would like to compare two dates in the same row and return a true
> > or
> > false statement.
> >
> > How do I do this?

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
compare dates Vic Microsoft Excel Misc 2 1st May 2009 03:30 AM
Re: compare dates Fred Smith Microsoft Excel Misc 0 30th Apr 2009 02:08 PM
compare 2 tables of dates to find the preceding dates Babi Microsoft Excel Worksheet Functions 3 28th Oct 2008 05:52 AM
Compare dates Tom Microsoft Access Queries 2 9th Oct 2003 09:44 PM
Re: how to compare two dates Rick Brandt Microsoft Access Getting Started 0 14th Aug 2003 06:19 PM


Features
 

Advertising
 

Newsgroups
 


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