calculate date if date entered in cell, do nothing if blank
I am trying to work out a formula to display a second date if a date is entered into a specific cell, but to leave it blank if nothing is entered.
In C2 we enter the date a participant has taken a break from our program, they have 28 days to return before they are exited, in D2 I want to calculate the date of the last day they can return.
=C2+28 works fine for displaying the end date, but when dragged down returns 28/01/1900 when there is no date entered in C2, which makes for a confusing spreadsheet
I need a formula that will only return a date in D2 if C2 has a date entered
Any help really appreciated
|