How to turn a number range into a date
 

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

How to turn a number range into a date
 

Hi,

You don't say what happens if the number = 19 so I have assumed + 10

=IF(A1<=19,TODAY()+10,TODAY()+33)


if it's the other way around use

=IF(A1<19,TODAY()+10,TODAY()+33)

Mike
Mike

"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

How to turn a number range into a date
 

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