Wednesday, April 10, 2013

yogi_From Table Of WeekEnds Worked And Dates TakenOff Compute Row By Row Date When Comp Expires

                                          Google Spreadsheet   Post  #1108
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 10, 2013
user Stoked Charlie :(!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(A8) + 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?



A) =if(B19="1", (=DATEVALUE(A19) + 90), "")
B) Formula in d19 - comp time sheet
c) 100 (1 + 90 = 100.)

Basically, when i add dates in column A, i want the "=DATEVALUE(A*) + 90" to appear in column C.  After I add a date in column B, I want the number in column C to disappear.  Hence, the reason to have Column C only populate when column B is empty. 

Thanks in advance for your help.
Attachments (1)
Copy of Vacation _ Comp _ Sick Time 2013.xlsx
4 KB   View   Download
here we go