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     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(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?

-Charlie

---

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.
-Charlie
Attachments (1)
Copy of Vacation _ Comp _ Sick Time 2013.xlsx
4 KB   View   Download
------------------------------------
here we go