Google Spreadsheet Post #1108
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 10, 2013
user Stoked Charlie :(http://productforums.google.com/forum/?zx=ik561dw2e7n8#!category-topic/docs/spreadsheets/GUE7d6IjHQk)
if a cell b2 is blank, add 90 days to the date in cell a2. if cell b2 has data leave cell c2 blank
I have a spreadsheet that keeps track of comp days when i work the weekends. Currently, Column A holds the date I worked, Column B holds the date I took off and Column c holds when the "comp day" expires (90 days later)
Cell A8 = "1/12/13"
Cell B8 =
Cell C8 "=DATEVALUE() + 90"
Cell C8 - shows "4/12/13"
I want to have column c calculate 90days after cell a if and only if cell b is blank ("") & Column C is empty
Is there a way to do this?