Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
Is there a way to have a formula look at a cell and if the date in that cell
is between two certain dates to display it, otherwise leave blank...for example: 2/15/2009 I want a formula to display the above date if it is equal to or between 2/8/2009 & 2/15/2009 Any ideas? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
You can check the date in one cell and display it in another only if it is
between two dates but you can not use a formula in the same cell... You may use conditional formatting with white FONT as a workaround. You can have theis formula in B1 to check dates in A1 =IF(AND(A1DATE(2009,5,1),A1<DATE(2009,6,1)),"With in range","Out of range") or =IF(AND(A1DATE(2009,5,1),A1<DATE(2009,6,1)),A1,"" ) "lightbulb" wrote: Is there a way to have a formula look at a cell and if the date in that cell is between two certain dates to display it, otherwise leave blank...for example: 2/15/2009 I want a formula to display the above date if it is equal to or between 2/8/2009 & 2/15/2009 Any ideas? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
First format the cell to have the same font color as background color (say
both white). Then: Format Conditional formatting... Cell value is between 39852 and 39859 and specify a black font color. -- Gary''s Student - gsnu200854 "lightbulb" wrote: Is there a way to have a formula look at a cell and if the date in that cell is between two certain dates to display it, otherwise leave blank...for example: 2/15/2009 I want a formula to display the above date if it is equal to or between 2/8/2009 & 2/15/2009 Any ideas? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
=IF(AND(A2=DATE(2009,2,8),A2<=DATE(2009,2,15)),A2 ,"") and format the cell
appropriately. -- David Biddulph "lightbulb" wrote in message ... Is there a way to have a formula look at a cell and if the date in that cell is between two certain dates to display it, otherwise leave blank...for example: 2/15/2009 I want a formula to display the above date if it is equal to or between 2/8/2009 & 2/15/2009 Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |