Salesforce and other SMB Solutions are coming soon. ×

# Calculation based on Value List

## Recommended Posts

I have a field that has 5 values selectable by radio buttons:

Term Lease, Mth to Mth, 3 Mths, 6 Mths, and 9 Mths.

I want to be able to calculate the lease term end date based on the value selected.

It Term Lease = End Date,

If Mth to Mth = Today + 30 or 31 days dependent on todays date.

If 3 Mths = Today + 90, 91, or 92 days dependent on todays date.

Etc. . . . .

I can't seem to get the formula to work based on this scenario.

##### Share on other sites

Ok, I figured out how to get the calculation by adding 30,60 etc. to a "CurrentDate" Field - however, how do I account for months with different days of the month?

Thanks!

##### Share on other sites

Try using

Date( Month(Status(CurrentDate)) + x, Day(Status(CurrentDate)), Year(Status(CurrentDate)) )

where x is the number of months to be added. Then you won't need to worry about the number of days in the month.

If you are using version 7, substitute Get in place of Status.

#### Archived

This topic is now archived and is closed to further replies.

• ### Images

• By Soliant Consulting,
• By Soliant Consulting,
• By Soliant Consulting,
• ### Forum Statistics

• Total Topics
33.7k
• Total Posts
141.6k
×
×
• Create New...