0

I have an [assessment] and a [reassessment] column and I want to calculate the new reassessment due date.

If the [assessment] date is blank then I want the result to be blank.

If the [assessment] date is not blank and the [reassessment] date is blank then I want to add 3 years from the [assessment] date.

If the [reassessment] date is not blank then I want to add 6 years from the [assessment] date.

I need help. The formula below give me an error and this is where I am at.

=OR(IF(ISBLANK([Assessment]),(IF(NOT(ISBLANK([Reassessment])), "", DATE(YEAR([Assessment])+3,MONTH([Assessment]),DAY([Assessment])), DATE(YEAR([Assessment])+6,MONTH([Assessment]),DAY([Assessment]))

Thanks in advance!

  • I resolved it. =IF(ISBLANK([Assessment]), "",IF(ISBLANK([Reassessment]), DATE(YEAR([Assessment])+3,MONTH([Assessment]),DAY([Assessment])), DATE(YEAR([Assessment])+6,MONTH([Assessment]),DAY([Assessment])) thanks – Ronald MacDonald Dec 28 '18 at 19:31
  • You can answer your own question in below(answer) section. – Ganesh Sanap Dec 28 '18 at 19:46
  • I resolved it. =IF(ISBLANK([Assessment]), "",IF(ISBLANK([Reassessment]), DATE(YEAR([Assessment])+3,MONTH([Assessment]),DAY([Assessment])), DATE(YEAR([Assessment])+6,MONTH([Assessment]),DAY([Assessment])) – Ronald MacDonald Jan 3 at 14:38
1

I resolved it using below formula:

=IF(ISBLANK([Assessment]), "",IF(ISBLANK([Reassessment]), DATE(YEAR([Assessment])+3,MONTH([Assessment]),DAY([Assessment])), DATE(YEAR([Assessment])+6,MONTH([Assessment]),DAY([Assessment]))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.