Hello!

I've spent over two hours trying to figure out how to get this done right.

Column C is the Purchase Order Release Date
Column D is the Goods Receipt Post Date
Column E is the Invoice Receipt Post Date

Column C will always be the start date when using DAYS360, however, since the Goods Receipt Date sometimes preceeds the Invoice Receipt Date (and vice versa), I need DAYS360 (or an equivalent function) to calculate the number of days from Column C Row 1 to the *LATTER* of the dates found in COLUMN D Row 1 and COLUMN E Row 1.

Any assistance would be sooo appreciated. Thanks in advance for your help!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Output Parameters with Stored Proc ADO.NET
http://www.eggheadcafe.com/tutorials...s-with-st.aspx

Forget Days360. Just subtract dates to get the number of days difference.

Try this:
=max(d1,e1)-c1
Format as number

--
Regards,
Fred


<Aimee Shaw wrote in message ...
Hello!

I've spent over two hours trying to figure out how to get this done right.

Column C is the Purchase Order Release Date
Column D is the Goods Receipt Post Date
Column E is the Invoice Receipt Post Date

Column C will always be the start date when using DAYS360, however, since the
Goods Receipt Date sometimes preceeds the Invoice Receipt Date (and vice
versa), I need DAYS360 (or an equivalent function) to calculate the number of
days from Column C Row 1 to the *LATTER* of the dates found in COLUMN D Row 1
and COLUMN E Row 1.

Any assistance would be sooo appreciated. Thanks in advance for your help!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Output Parameters with Stored Proc ADO.NET
http://www.eggheadcafe.com/tutorials...s-with-st.aspx