Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with Dates
One column in my spreadsheet contains dates in the format mm/dd/yyyy.
Many of the cells in this column are blank, but for those that contain a date, I want to determine which ones come after 05/13/2007. I have created a column next to the date column, in which I hoped to put an X in each cell that neighbors a date after 5/13/2007. I have tried to use the formula =IF(AND(cell=DATE(2007,5,13),cell<=DATE(2007,7,5) ),"X","O") ... As this has worked for me in the past. In this case, though, it is putting an O in every cell regardless of what the date is. Is there a better formula that I can use? Might there be a reason that this worked on other spreadsheets, but not on this one? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with Dates
On Jul 5, 4:59 pm, wrote:
One column in my spreadsheet contains dates in the format mm/dd/yyyy. Many of the cells in this column are blank, but for those that contain a date, I want to determine which ones come after 05/13/2007. I have created a column next to the date column, in which I hoped to put an X in each cell that neighbors a date after 5/13/2007. I have tried to use the formula =IF(AND(cell=DATE(2007,5,13),cell<=DATE(2007,7,5) ),"X","O") ... As this has worked for me in the past. In this case, though, it is putting an O in every cell regardless of what the date is. Is there a better formula that I can use? Might there be a reason that this worked on other spreadsheets, but not on this one? P the folllowing formula cell B1 and copy it to the bottom of you worksheet. =IF(ISBLANK(A1),"",IF(A105/07/2007,"X","") Better yet conditional Format column A =A105/07/2007 andformat to change color. ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with Dates | Excel Worksheet Functions | |||
working with dates | Excel Worksheet Functions | |||
Working with dates | Excel Worksheet Functions | |||
working with dates | Excel Worksheet Functions | |||
working with dates | Excel Discussion (Misc queries) |