Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum If range of dates date range, sum totals | Excel Worksheet Functions | |||
Question about using MIN/MAX, INDEX with Date range | Excel Worksheet Functions | |||
Date Range Question | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) |