Try Be aware that if you need the value in col C for further calculations the "" result will probably trigger errors

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you Pecoflyer, I have copied the formula but I am still getting #VALUE! in column C when a start date or an end date is entered. How can I stop this appearing?