Calculating difference between date columns

Question

- MOSS 2007 SP2

Let's assume I have the following Date fields: [Start_date], [End_date], [Revised_end_date]

I understand that I can easily calculate the difference between two date fields by using a calculted column with an expression of:

 =DATEDIF(Start_date,End_date,"D")

But what if I want to only calculate between [Start_date] and [End_date] as long as [Revised_end_date] is null.  If not null, then I want the difference between [Start_date] and [Revised_end_date] (ideally in X Months, X Days format)

Edit - To clarify, I am not very strong with building the expressions.  Any help or guidance on the correct expression to achieve this (even if it doesn't use DATEDIF) would be appreciated. 

Answer 1

If I understand correctly, then you should be able to wrap your DATEDIF calculation in an IF.  Something like this person did: http://www.eggheadcafe.com/software/aspnet/33772815/sharepoint-list-calculated-column.aspx

Here is a good reference for calculated field fomulas for WSS 3: http://msdn.microsoft.com/en-us/library/bb862071(v=office.12).aspx

---

Ann

Answer 2

Hi,

YES i agree with abui. You have to use logical functions  in your calculated column. Please follow this link and create your formula based on your requirement

http://www.endusersharepoint.com/2009/02/06/taming-the-elusive-%E2%80%9Ccalculated-column%E2%80%9D-logic-part-1/

Hope it could help

---

Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"