do not know if this can be done with SharePoint calculation.
what i am trying to do is calculate between two or three dates. i know the formula for calculating between two dates but it is the latter that i am trying to figure out.
right now i know how to calculate between two dates but wondering if it will allow me to calculate to another date if that field is filled in. So if field one is the auto today date and field two is the begin date and field three is another date filled in at a later date.
i want it for the time being to calculate the number of days between field one and field two it gives me the number of days. then if field three gets filled in then it calculates the number of days between field one and field three.
any help would be greatfull
Thank you for the response and help. the first response work with a little tweek as i was not working at first.
the last bit of DateThree-DateOne should actually be DateThree-DateTwo