PC Review

Reply

Rate Thread

Compare dates

gcotterl

Guest

Posts: n/a

28th Sep 2010

How can I determine if the date in B1 is after the date in A1?

This is how each cell is formatted:

A1: 06/23/2000 (format: number: custom: mm/dd/ccyy)
B1: 10-01-2003 (format: number: general)

Reply With Quote

Reply

« Re: BusSeriesQuestion | Compare dates »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

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