I am trying to create a policy monitoring worksheet wherein when i enter an initiating date say in column A2 the expiration date (which is every 2 years) will automatically enter in column C2. However, if a policy has just renewed, the initiating date will still be in A2 and the renewal date will be entered in column B2. Automatically the computer calculates the expiration date based on the date entered in column B2.
Can you help me with this.![]()
Bookmarks