Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Assuming date in A2, and value in B2
In C2: =(B219)*23+10+A2 "ljimages" wrote: I need some help. I am trying to turn a number in a specific range into a date I have a date and a value of the data for that date. I need to know how to turn that value into a date. If the number is below 19 I need the date to be 10 days more than the date of the value. If the number is above 19 the date needs to be 33 days more than the date Example Date Value Date if value <19 8/20/09 13 (Date would be 8/20/09 +10 days) Date Value Date if Value 19 8/20/09 22 (Date would be 8/20/09+33 days) If the range is above 19 I need the date to be 33 days more than the date of the value I don't know if this is possible but I have tried several functions and formulas and nothing works for me. Any help would be appreciated. -- ljimages |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of dates falling in a date range | Excel Worksheet Functions | |||
counting the number of dates in a date range | Excel Worksheet Functions | |||
Number counts within Date Range | Excel Worksheet Functions | |||
Turn off Automatically convert number to date | Excel Discussion (Misc queries) | |||
Number of Days in a Date Range | Excel Discussion (Misc queries) |