days360

Hi all, I'm curious if there's a formula to do the opposite of DAYS360. That is, DAYS360 figures out the number of days between two dates on a 360 day basis. I want to make a formula that adds a number of days on a 360 day basis. So if my starting date is 5/25/19 and I add 6 days, it should...

Hello Everyone, First post here and I could use some help. Days360(7/1/2017,6/30/2018) gives me 359 days when Days360(1/1/2017,12/31/2017) gives me 360. How do I get the former to give me 360 or is there something inherently true with the former formula that will always give me 359? I have also...

I want t enter three arguments into one cell: 1. Calculate total days overdue 2. Mark "Received" if date in received column 3. Leave blank if not overdue So far, I have =IF(G3>1,"RECEIVED",DAYS360(F3,TODAY())) and I get arguments 1 and 2, but I can't figure out how to add argument 3. I've tried...