Home |
Search |
Today's Posts |
#1
|
|||
|
|||
This is a date question...
Here is what I am trying to do.
I have two columns. The values in the first column, let's call them Begin Date. The values in the second column we will call End Date. What I am trying to do is creat (in a third column) a Yes or No value based on the following criteria: If (amount of time) between Begin Date and End Date is less than 1 week, put a value of Yes in the third column for this record. If not, put a No. Can this be done? -- RSF |
#2
|
|||
|
|||
One way:
XL stores dates as long integer offsets from a base date, so you can use regular math on them: =IF(end_date - begin_date)<7,"Yes","No") In article , Robert wrote: Here is what I am trying to do. I have two columns. The values in the first column, let's call them Begin Date. The values in the second column we will call End Date. What I am trying to do is creat (in a third column) a Yes or No value based on the following criteria: If (amount of time) between Begin Date and End Date is less than 1 week, put a value of Yes in the third column for this record. If not, put a No. Can this be done? |
#3
|
|||
|
|||
Hi,
=IF(A1-B1<7,"Yes","No") where A1 nests begin date and B1 nests end date. Regards, A "Robert" wrote: Here is what I am trying to do. I have two columns. The values in the first column, let's call them Begin Date. The values in the second column we will call End Date. What I am trying to do is creat (in a third column) a Yes or No value based on the following criteria: If (amount of time) between Begin Date and End Date is less than 1 week, put a value of Yes in the third column for this record. If not, put a No. Can this be done? -- RSF |
#4
|
|||
|
|||
JE had a typo in the formula, should be
=IF(end_date - begin_date<7,"Yes","No") -- HTH RP (remove nothere from the email address if mailing direct) "JE McGimpsey" wrote in message ... One way: XL stores dates as long integer offsets from a base date, so you can use regular math on them: =IF(end_date - begin_date)<7,"Yes","No") In article , Robert wrote: Here is what I am trying to do. I have two columns. The values in the first column, let's call them Begin Date. The values in the second column we will call End Date. What I am trying to do is creat (in a third column) a Yes or No value based on the following criteria: If (amount of time) between Begin Date and End Date is less than 1 week, put a value of Yes in the third column for this record. If not, put a No. Can this be done? |
#5
|
|||
|
|||
In article ,
"Bob Phillips" wrote: JE had a typo in the formula, Thanks for the correction! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Date Display Question | Excel Discussion (Misc queries) | |||
Another Date Question | Excel Discussion (Misc queries) | |||
Date function question | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) |