Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a date in cell A1 = 05/18/04
I need a formula for cell A2 to show a date range of A1+13days to A1+44days (end result in A2 should be something like: 5/31/04 - 7/01/04 Then, in cell A3 I have another date that represents when an item was received. I need a formula in cell A4 that will identify with a "0" or a "1" if the date the item was received (cell A3) is within the date range in cell A2. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update cell based on date range | Excel Discussion (Misc queries) | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions |