Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |