| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Less Than Greater Than Date Question
I need to put in a formula that simply says if a date in a cell is less than
a particular specified date. I'm fairly good with Excel, but I can't figure this out. Major brain freeze, I'm sure. Let's say A1 has 1/31/2005 in it. In B1 (and copy/pasted all the way down), I want to show if A1, A2, A3, etc. is less than or equal to 1/1/2006. So, in this case, B1 would show "YES". Thoughts? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Less Than Greater Than Date Question
=if(A1<date(2006,1,1),"Yes","No")
-- http://HelpExcel.com "Paperback Writer" wrote: I need to put in a formula that simply says if a date in a cell is less than a particular specified date. I'm fairly good with Excel, but I can't figure this out. Major brain freeze, I'm sure. Let's say A1 has 1/31/2005 in it. In B1 (and copy/pasted all the way down), I want to show if A1, A2, A3, etc. is less than or equal to 1/1/2006. So, in this case, B1 would show "YES". Thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Date in a cell if other cell is greater than 1 | Excel Worksheet Functions | |||
| Date format Question | Excel Discussion (Misc queries) | |||
| SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hybrid Mode
