LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Date Range Question

Assume there is a date range from 1/1 to 3/31 (i.e., first quarter).

In cell A2 I have a start date, in cell B2 I have an end date.

If the start date is greater than the end date
or the end date is less than the start date
or the dates are not within the date range
display "Date Error" in cell C3

Can someone help with a macro or formula for this problem?

Thanks in Advance
--
Rodman Veney
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum If range of dates date range, sum totals Stilmovin Excel Worksheet Functions 7 December 16th 08 05:49 PM
Question about using MIN/MAX, INDEX with Date range ML Srini Excel Worksheet Functions 3 October 4th 07 12:59 AM
Date Range Question elfmajesty Excel Discussion (Misc queries) 2 January 13th 06 01:50 PM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Excel Worksheet Functions 2 September 1st 05 01:59 PM
SUMPRODUCT with date range question Rob V Excel Discussion (Misc queries) 1 January 31st 05 03:55 PM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"