LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help please what am i doing wrong? Nevyn Excel Discussion (Misc queries) 1 February 9th 10 10:50 PM
Insert Calculated Field (wrong Qty*Price = wrong Amount) Edmund Excel Discussion (Misc queries) 8 October 4th 07 12:13 PM
Any wrong with this? Jo[_2_] Excel Discussion (Misc queries) 1 August 2nd 07 09:48 PM
Min Max What's Wrong? shep Excel Worksheet Functions 4 October 4th 06 09:46 PM
What am I doing wrong? Jeff New Users to Excel 4 March 6th 05 03:05 AM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"