J
Judy
I have placed a control in a form to calculate a due date based on a start
date I enter in a field. My problem is if there isn't a date in the start
date field, my due date field displays #Error. Here's my formula:
=DateSerial(Year([CollabStartDate]),Month([CollabStartDate]),Day([CollabStartDate])+15)
Is there a way to make it not show the #Error until I have a date to enter
in the start date field?
I have 4 different due dates in my form, tracking the due dates of the
various phases of the project: review, edit, collaboration, approval, so the
start dates for each of activities don't get entered until the previous phase
has completed. Ideally, I'd also like to get notified when a due date has
arrived; haven't figured that one out at all yet.
Thanks for any help.
date I enter in a field. My problem is if there isn't a date in the start
date field, my due date field displays #Error. Here's my formula:
=DateSerial(Year([CollabStartDate]),Month([CollabStartDate]),Day([CollabStartDate])+15)
Is there a way to make it not show the #Error until I have a date to enter
in the start date field?
I have 4 different due dates in my form, tracking the due dates of the
various phases of the project: review, edit, collaboration, approval, so the
start dates for each of activities don't get entered until the previous phase
has completed. Ideally, I'd also like to get notified when a due date has
arrived; haven't figured that one out at all yet.
Thanks for any help.