| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In XLS, how do IF stmt for IF a date is after another date...?
In Excel, how can I create an IF statement to return a value or text IF a
DATE is after or before another date? It doesn't seem to recognize dates and is returning all the same value in the current IF statement I've created. I'm not sure if it has something to do with formatting but I've changed the formats to Dates, General, Text, etc and the IF statement still doesn't work........ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In XLS, how do IF stmt for IF a date is after another date...?
With Excel dates in A1 and B1 (note: not text items that look like
dates), try this in C1: =IF(A1B1,"A1 after B1",IF(B1A1,"A1 before B1","same dates")) Hope this helps. Pete On May 3, 4:43 pm, wiggledg wrote: In Excel, how can I create an IF statement to return a value or text IF a DATE is after or before another date? It doesn't seem to recognize dates and is returning all the same value in the current IF statement I've created. I'm not sure if it has something to do with formatting but I've changed the formats to Dates, General, Text, etc and the IF statement still doesn't work........ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In XLS, how do IF stmt for IF a date is after another date...?
And make sure that ToolsOptionsCalculation is set to "Automatic"
Gord Dibben MS Excel MVP On 3 May 2007 08:54:24 -0700, Pete_UK wrote: With Excel dates in A1 and B1 (note: not text items that look like dates), try this in C1: =IF(A1B1,"A1 after B1",IF(B1A1,"A1 before B1","same dates")) Hope this helps. Pete On May 3, 4:43 pm, wiggledg wrote: In Excel, how can I create an IF statement to return a value or text IF a DATE is after or before another date? It doesn't seem to recognize dates and is returning all the same value in the current IF statement I've created. I'm not sure if it has something to do with formatting but I've changed the formats to Dates, General, Text, etc and the IF statement still doesn't work........ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In XLS, how do IF stmt for IF a date is after another date...?
Thanks, I'm not sure why a date can't be hard coded into the formula, but it
works now that I have the formula targeted to a cell. Thanks again!!! "Pete_UK" wrote: With Excel dates in A1 and B1 (note: not text items that look like dates), try this in C1: =IF(A1B1,"A1 after B1",IF(B1A1,"A1 before B1","same dates")) Hope this helps. Pete On May 3, 4:43 pm, wiggledg wrote: In Excel, how can I create an IF statement to return a value or text IF a DATE is after or before another date? It doesn't seem to recognize dates and is returning all the same value in the current IF statement I've created. I'm not sure if it has something to do with formatting but I've changed the formats to Dates, General, Text, etc and the IF statement still doesn't work........ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In XLS, how do IF stmt for IF a date is after another date...?
You could use DATEVALUE("1/1/2007") instead of one of the cell
references to hardcode a date in the formula and to allow it to be understood more easily, but isn't it easier to refer to a cell that contains the date? Hope this helps. Pete On May 3, 10:26 pm, wiggledg wrote: Thanks, I'm not sure why a date can't be hard coded into the formula, but it works now that I have the formula targeted to a cell. Thanks again!!! "Pete_UK" wrote: With Excel dates in A1 and B1 (note: not text items that look like dates), try this in C1: =IF(A1B1,"A1 after B1",IF(B1A1,"A1 before B1","same dates")) Hope this helps. Pete On May 3, 4:43 pm, wiggledg wrote: In Excel, how can I create an IF statement to return a value or text IF a DATE is after or before another date? It doesn't seem to recognize dates and is returning all the same value in the current IF statement I've created. I'm not sure if it has something to do with formatting but I've changed the formats to Dates, General, Text, etc and the IF statement still doesn't work........- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In XLS, how do IF stmt for IF a date is after another date...?
I'd use =date() to make sure the date was unambiguous.
=if(date(2007,12,25)a1, ... (I'm not sure why you'd hardcode both dates in the cell, though.) wiggledg wrote: Thanks, I'm not sure why a date can't be hard coded into the formula, but it works now that I have the formula targeted to a cell. Thanks again!!! "Pete_UK" wrote: With Excel dates in A1 and B1 (note: not text items that look like dates), try this in C1: =IF(A1B1,"A1 after B1",IF(B1A1,"A1 before B1","same dates")) Hope this helps. Pete On May 3, 4:43 pm, wiggledg wrote: In Excel, how can I create an IF statement to return a value or text IF a DATE is after or before another date? It doesn't seem to recognize dates and is returning all the same value in the current IF statement I've created. I'm not sure if it has something to do with formatting but I've changed the formats to Dates, General, Text, etc and the IF statement still doesn't work........ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
