if statement query

[casa]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Wondered if this might be a simple question and I'm just not thinking laterally enough (still quite amateur user of excel):<o></o>
<o> </o>
I would like to do a calculation using the following fields-<o></o>
<o> </o>
Date referral Booked date, seen date, if seen, still waiting, census date.<o></o>
Received,<o></o>
<o> </o>
<o> </o>
I’m sure I could make it neater but anyway…<o></o>
<o> </o>
<o> </o>
In the ‘seen date’ column there may not always be a date. – it could be a date or it could be blank.<o></o>
<o> </o>
What I would like to do is a calculation though an if statement to say <o></o>

• if there’s a date in the ‘seen date’ field then calculate the difference between the ‘date referral received’ and the ‘seen date’<o></o>
• if there is no date in the ‘seen date’ field then populate the ‘still waiting’ field with the difference between the date referral received and the census date.<o></o>

<o> I need to graph the results afterwards as well but need to get the functionality of the data right first.</o>
Hope this makes sense,<o></o>
Thank you in advance,<o></o>
Casa<o></o>

 

[BGY23]

In still waiting column type.......

If(seen date="",date referred received-census date,date seen-referal received date)

Where I've put your column headings just type inthe cell address and copy it down.


I have changed the formula assuming that the seen date is after the referal. If the census date is usually after the referal you'll need to change that one as well.

 

[Weaver]

Assuming your headers start in A1 then your formulas start in row 2


if there’s a date in the ‘seen date’ field then calculate the difference between the ‘date referral received’ and the ‘seen date’<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

=IF(C2="",""C2-A2)

if there is no date in the ‘seen date’ field then populate the ‘still waiting’ field with the difference between the date referral received and the census date.<o></o>

=IF(C2="",""G2-A2)

 

[casa]

I was thinking it around the wrong way, much obliged to you both BGY23 and excelR8R,

I don't really need the second column at the end if not seen now which makes much more sense,

Thanks

Casa