Anna_C10Copper ContributorFeb 02, 2022Nested IF function Hello everyone, I am trying to create a nested IF function. Screenshot included for reference. The Number of Days column needs to calculate the number of days in the date span in columns C and D. I...Show More
Anna_C10Copper ContributorFeb 02, 2022JMB17 thank you for replying.The formula you have suggested is bringing up a #VALUE! error
JMB17Bronze Contributor to Anna_C10Feb 02, 2022Are the empty cells not truly empty? If they contain the empty string ( "" ), then you would get #Value. You could try this instead:=IF(AND(C3<>"", D3<>""), D3-C3+1, "")
