If a1=1 then e1 =c1+17 - dates

  • Thread starter Thread starter JennyP
  • Start date Start date
J

JennyP

I have a workflow spreadsheet with the following column
headings:
column a. Name,
column b. work in (date format)
column c. type (1, 2, 3 or 4 - 1 for 7 days, 2 for 14 days
3 for 21 days 4 for 28 days)[general number format]
column d. Due (date due)
I need to create a formula so that if the "type" is 2 in
cell c1, date in cell b1 is 9th July 2004 then the value
in cell d1 would be 14 days from the date in cell b (ie 23
July 2004)
 
Hi Jenny,

Assuming that your data starts in Row 2, try:

=IF((C2=2)*(B2=DATE(2004,7,9)),B2+14,"")

Hope this helps!
 
Put this in D1

=B1+C1*7

if you want to trap for empty cells in either B1 or C1

=IF(COUNT(B1:C1)<>2,"",B1+C1*7)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top