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

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?

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

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?

In article ,
"Bob Phillips" wrote:

JE had a typo in the formula,

Thanks for the correction!