Im no expert but I seem to be struggling with this.
I have a calculated column field called [Review Days] for which I hope to enter an amount of days that a document will need reviewing. 1 year will equal 365 days, 2 years, 720 days etc.
I can get this to work no problem.. the problems is, if [Review Days] is blank then I want to default this field value, [Next Review Date] equals [modified] + 1825 days or 5 years.
I kinda see something like this:
=IF( ISBLANK([Review Days]) , "" , Modified+1825 , [Modified]+[Review Days] )
Any help will be much appreciated.
Thanks Mike