DAYS360 where Start Date is Static and End Date is Latter of Two Dates


A

Aimee Shaw

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/tutorial...a-fceae9f9d99e/output-parameters-with-st.aspx
 
Ad

Advertisements

F

Fred Smith

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top