Hello,
I am trying to subtract two dates using DatedIf, ie., DatedIf(C5-C6,"D", but the two dates I am subtracting are the same dates (08/03/2023 - 08/03/2023) and should equal zero but I am getting a #Value! error. I've tried changing the date formatting to several different formats and even tried general, text and custom and still get the error. I am using O365 Excel. Thank you!
I am trying to subtract two dates using DatedIf, ie., DatedIf(C5-C6,"D", but the two dates I am subtracting are the same dates (08/03/2023 - 08/03/2023) and should equal zero but I am getting a #Value! error. I've tried changing the date formatting to several different formats and even tried general, text and custom and still get the error. I am using O365 Excel. Thank you!