3,887 questions
HI @Musical1FLRefer the link below this will help you out.
https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38
Excel Formula Issue - Subtracting two Dates to get a "Total number of days" to complete a process
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 93%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Musical1FL
0
Reputation points
I am subtracting two dates to create a number of days it has taken to process an application for a volunteer organization. I'm using the standard Excel formula to subtract Column A from column B ( for example... June 30 - August 30th = 60 Days) --- The problem is when the application has not been completed and the "Completed" column (B) is blank, the "Days" Column (showing the result) show's -44083 or some other number relative to the total number of days Excel allows you to track. So I need an "if - then" statement that says IF Column B is "blank" - render "0" or blank in the 'days" (Result) Column C---- the formula I'm using is =DAYS360(F4,M4) but I need an IF THEN STatement to show "0" or blank in the results column, when column B is empty (no completion date)
Microsoft 365 and Office Excel For business Windows
{count} votes
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2024-08-19T01:56:55.3133333+00:00 Hi @Musical1FL ,
If the response of Barry Schwarz is helpful, please click "Accept Answer" and upvote it.
Sign in to comment
2 answers
Sort by: Most helpful
-
Tejas Satish Dhavale 570 Reputation points Student Ambassador2024-08-08T13:46:44.6666667+00:00 -
Musical1FL 0 Reputation points
2024-08-08T13:53:14+00:00 Hi Tejas, the general formula is working but the challenge is... when the 2nd column (Completion Date) is empty (the process we're doing has not been completed yet) I want the Results Column to render "0" or have the column be blank... right now when the 2nd column is empty the RESULTS column (Number of Days) is rendering some long number... like it's subtracting the date since the beginning of time! So I think I need an "IF (column) = blank, results (called Total Days) column = "0" does that make sense? I'm having trouble writing that IF / THEN statement
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz 3,746 Reputation points2024-08-08T15:20:32.55+00:00 You can test for data in the completion date cell with the ISBLANK function, by comparing the value to "" (the empty string), or by verifying the value is greater than 0. Using the example you provided, try
=IF(ISBLANK(M4),"",DAYS360(F4,M4))-
Musical1FL 0 Reputation points
2024-08-08T15:54:12.9+00:00 Barry I really appreciate the help! So what you sent me goes in what I've called "Total Days" column which is the one that would render either the number of days OR if Column M4 is empty then it would show blank. Correct?
-
Musical1FL 0 Reputation points
2024-08-08T16:00:32.4133333+00:00 Hi Barry, OK I put that formula in the field that renders the number of days and now it DOES work when Mx field is blank, but when I put a date in the field it's not giving me a total number of days, so it's not calculating like it was before. Any suggestions?
-
Musical1FL 0 Reputation points
2024-08-08T17:34:23.59+00:00 All good Barry, I was typing it in wrong... thanks so much for your help!!!
-
Barry Schwarz 3,746 Reputation points
2024-08-09T00:24:15.8566667+00:00 Mark the answer as Accepted please.
Sign in to comment -