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 result in 6/1/19 instead of 5/31/19. Is this possible?
Thanks for any help.
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 result in 6/1/19 instead of 5/31/19. Is this possible?
Thanks for any help.