Hi,
I'm trying to create a sheet which tracks the due date of maintenance tasks based on a date started and adding a number of working days depending on the priority of the task. So far this is in 3 cells:
1: Date
2: Number of days from a drop down list
3: =WORKDAY(A1,B1)
This correctly shows the due date of the job. However, the =WORKDAY formula is showing the date 00/01/1900 on lines where the date field is empty. I was trying to work around this by adding the ISBLANK formula. My attempt so far was:
=IF(ISBLANK(A1),[ ],[=WORKDAY(A1,B1)])
However this comes up with a syntax error for the [value_if_true] field. If I put anything in the field other than a space it comes up with the "There's a problem with this formula" error message.
Frankly, I have no idea how to fix this!
Bookmarks