| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Age Date Between Two Dates to Return Value as 30, 60, 90 day
Hi,
How do I calculated between two dates to return the value as 30, 60, 90 day. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Age Date Between Two Dates to Return Value as 30, 60, 90 day
Nath wrote:
Hi, How do I calculated between two dates to return the value as 30, 60, 90 day. One way: =CEILING(day2 - day1,30) Substitute day2 and day1 with references to your actual dates. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Age Date Between Two Dates to Return Value as 30, 60, 90 day
Sorry, that did not work. I'm doing something work. What I'm looking for is:
Cell A1 = 6/8/07 A2 = 12/11/08 I need it to return the value between the two date as 30,60,90,180,360, and 1yr+ "smartin" wrote: Nath wrote: Hi, How do I calculated between two dates to return the value as 30, 60, 90 day. One way: =CEILING(day2 - day1,30) Substitute day2 and day1 with references to your actual dates. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Age Date Between Two Dates to Return Value as 30, 60, 90 day
Ah, that's a shade different than your original requirements, no?
Create a little table in an out-of-the-way place. I will use X1:Y6 to demonstrate: X Y -------------- 1E+31 1yr+ 360 360 180 180 90 90 60 60 30 30 Now given your dates in A1 and A2 this will return the age bucket: =INDEX(X1:Y6,MATCH(A2-A1,X1:X6,-1),2) Nath wrote: Sorry, that did not work. I'm doing something work. What I'm looking for is: Cell A1 = 6/8/07 A2 = 12/11/08 I need it to return the value between the two date as 30,60,90,180,360, and 1yr+ "smartin" wrote: Nath wrote: Hi, How do I calculated between two dates to return the value as 30, 60, 90 day. One way: =CEILING(day2 - day1,30) Substitute day2 and day1 with references to your actual dates. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Age Date Between Two Dates to Return Value as 30, 60, 90 day
Another way..
=LOOKUP(A2-A1,{0,30,60,90,180,360,361},{0,30,60,90,180,360,"1 yr+"}) If this post helps click Yes --------------- Jacob Skaria "Nath" wrote: Sorry, that did not work. I'm doing something work. What I'm looking for is: Cell A1 = 6/8/07 A2 = 12/11/08 I need it to return the value between the two date as 30,60,90,180,360, and 1yr+ "smartin" wrote: Nath wrote: Hi, How do I calculated between two dates to return the value as 30, 60, 90 day. One way: =CEILING(day2 - day1,30) Substitute day2 and day1 with references to your actual dates. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return date from range of dates with if statement | Excel Worksheet Functions | |||
| return TRUE if a date falls between two dates | Excel Worksheet Functions | |||
| Return Date using two dates and a word | Excel Discussion (Misc queries) | |||
| return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
| Return the latest date from a list of dates | Excel Worksheet Functions | |||
Linear Mode
