# I am trying to build a formula to calculate expiry date based on conditionality.

edited 02/09/24

So, if someone fills out the type of PRC as 'VSC', formula should add 'PRC issue date +3 years' to get PRC Expiry date,

another condition is, if staff fills out type of PRC as 'CRIC/CIPIC', the formula should add PRC issue date +6 months

=IF([PRC Type]@row = "VSC", DATE(YEAR([PRC Issue Date]@row) + 3, MONTH([PRC Issue Date]@row), DAY([PRC Issue Date]@row)), DATE(YEAR([PRC Issue Date]@row), MONTH([PRC Issue Date]@row) + 6, DAY([PRC Issue Date]@row)))

Does this look good or we can perfect it.

• ✭✭✭✭✭✭

Try this.

=IF([Type of PRC]@row = "VSC", DATE(YEAR([PRC Issue Date]@row) + 3, MONTH([PRC Issue Date]@row), DAY([PRC Issue Date]@row)), IF([Type of PRC]@row = "CRC/CIPIC", DATE(YEAR([PRC Issue Date]@row), MONTH([PRC Issue Date]@row) + 6, DAY([PRC Issue Date]@row))))

Hope that helps,

Dave

• ✭✭✭✭✭✭

Try this.

=IF([Type of PRC]@row = "VSC", DATE(YEAR([PRC Issue Date]@row) + 3, MONTH([PRC Issue Date]@row), DAY([PRC Issue Date]@row)), IF([Type of PRC]@row = "CRC/CIPIC", DATE(YEAR([PRC Issue Date]@row), MONTH([PRC Issue Date]@row) + 6, DAY([PRC Issue Date]@row))))

Hope that helps,

Dave

• Thanks Dave, that was very helpful.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!