If function: can the true result be a function?

[rb3883]

Hello and thanks for trying to help!

I have three columns: Date, Type, Start Date.

I have data in the "Date" and "Type" columns, but I need to populate the "Start Date" column.

Type can only take two values, A or B; date is just a range of future dates.

The logic is as follows: If Type = A then Start Date = Previous working day to the Date column (i.e. I need to use the Workday Function).

If Type = B then Start Date = Date (i.e. no change).

Any ideas?

Many thanks, Ryan

 

[xenou]

Basically - structure is:
=If(A,(Date-1),Date)

Doesn't this work? Date - 1 must be the workday function of course.

 

[xenou]

Maybe a bit more expanded assuming type in A1 and date in B1,

Formula in C1:
=IF(A1="TypeA",Workday(B1,-1),B1)

 

[rb3883]

Hi Mate,

That's what I thought and I can easily get the previous calendar day, getting the previous workday isn't working for me, the cell just shows the formula I have written, any other suggestions?

Thanks for coming back so quick!

Cheers, Ryan

 

[xenou]

the cell just shows the formula I have written, any other suggestions?

Strange. Try selecting the cell and pressing {Control + ~} (both keys at the same time...)
Edit: then re-enter the formula...

 

[rb3883]

Dude, I was missing a single comma! (below in bold), I can now sleep in peace.

=IF(A1="TypeA",Workday(B1,-1),B1)

Thanks for taking the time, Ryan

 

[xenou]

Like this?

book1
	A	B	C	D
1	Date	Type	StartDate
2	2/7/2009	Value1	2/6/2009
3	2/6/2009	Value2	2/6/2009
4	2/6/2009	Value1	2/5/2009
Sheet1

 

[xenou]

Oops...Saw you got it. Great.