calculate date if date entered in cell, do nothing if blank

ConfuddledOne · #1 11-04-2014, 04:32 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date field inserting merge date in blank field	Lesley	Mail Merge	5	09-30-2013 01:49 AM
Formula to calculate Date and Time	funkyfido	Excel	2	06-25-2013 04:25 PM
how to calculate backwards from a set finish date	ketanco	Project	1	02-07-2013 06:50 AM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM
Calculate date in word field	edwedw	Mail Merge	3	11-30-2011 02:10 PM