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


Aimee Shaw


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



Fred Smith

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

Try this:
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