+ Reply to Thread
Results 1 to 4 of 4

Calculating number of days, help.

Hybrid View

DollyMixture Calculating number of days,... 07-23-2014, 10:37 AM
Special-K Re: Calculating number of... 07-23-2014, 10:53 AM
DollyMixture Re: Calculating number of... 07-23-2014, 11:01 AM
DollyMixture Re: Calculating number of... 07-23-2014, 10:58 AM
  1. #1
    Registered User
    Join Date
    07-23-2014
    Location
    UK
    MS-Off Ver
    Home Student 2010
    Posts
    3

    Calculating number of days, help.

    Hello, a bit cheeky to dive on with a first post question but I can't seem to work it out.


    Using three different dates,calculate the the number of days if B is less than C answer = nil but if B is greater than C, the number of days C minus A.

    IE. A= 1/4/14 B= 31/7/2014 C=30/6/14

    Can anyone help with the argument string?

    Thank you

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: Calculating number of days, help.

    =if(b1<c1,0,c1-a1)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-23-2014
    Location
    UK
    MS-Off Ver
    Home Student 2010
    Posts
    3

    Re: Calculating number of days, help.

    Thank you so much. It works perfectly.

  4. #4
    Registered User
    Join Date
    07-23-2014
    Location
    UK
    MS-Off Ver
    Home Student 2010
    Posts
    3

    Re: Calculating number of days, help.

    Can it really be that easy? I've been making such heavy weather of this. Thank you, I will try it right now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculating the number of days
    By bremen22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2013, 12:06 PM
  2. calculating the number of days
    By Deanomcbeano in forum Excel General
    Replies: 12
    Last Post: 10-02-2012, 08:22 AM
  3. Calculating the number of days worked
    By Curtis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  4. [SOLVED] Calculating the number of days worked
    By Curtis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. Calculating number of days
    By Carlos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1