Days Between Two Dates

MRovi

New Member
Joined
Oct 23, 2013
Messages
10
I'm using a simple formula to subtract one date from the other to get the number of days in-between. I get a negative number for some of these that are missing dates. The dates will be filled in later. Is there a way to "ignore" the negative numbers for pivot tables and charts?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

NeonRedSharpie

Well-known Member
Joined
Jul 14, 2014
Messages
1,678
You could use an if statement:

Code:
=IF(Date1 - Date2 >= 0, Date1 - Date2, "To Be Completed")

and then filter out the "To Be Completed" entries.
 

MRovi

New Member
Joined
Oct 23, 2013
Messages
10
I spoke too soon. The pivot table still shows the negative numbers.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,371
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top