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
 
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

Similar Threads

Conditional Formating based on start and end dates 1
Lock sets of cells in a row and sort by date linked to each set 0
elapsed dates between start and end date and time 2
Match Dates in Two Cells and Ignore subsequent Cells 1
Sumproduct Question Working With Start and End Date Range 1
Return date of an action 0
start and end date on different rows 2
Return a value when Date x is between Date y and z 4

Top