Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's Wrong with This?
Hey guys-
Sorry for the multi-post, but didn't know which group this belongs to... I have 2 columns for dates. Sometimes only one of the two has an entry in it. Sometimes they both do. Although, they're NEVER both blank. I am trying to create a function that will compare the 2 dates (if there's even 2 there), and find out which one is the earliest of the two. If one date is missing from one column, it will just use the other date as the entry. Once it finds the earliest date between them, I want it to count how many days from the earliest date till today's date. I thought I did this right, but, the results are returning a #VALUE! answer. Can someone see what's going on here and tell me how to make this work? Thanks! =IF(L2="", DAYS360(V2,TODAY())), IF(V2="", DAYS360(L2,TODAY())), IF(L2<V2, DAYS360(L2,TODAY())), IF(L2V2, DAYS360(V2,TODAY())), IF(L2=V2, DAYS360(L2,TODAY())) D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help please what am i doing wrong? | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
Any wrong with this? | Excel Discussion (Misc queries) | |||
Min Max What's Wrong? | Excel Worksheet Functions | |||
What am I doing wrong? | New Users to Excel |