Hello,
I want to substract a couple of dates from todays exact date and time =NOW() and get the number of years, months and days that have passed since then.
But in some cases I get a negative number, which is in theory correct, but is there a way to avoid a - 4 and write it off as day 26 of the previous month or something along these lines? I need it to be an excel algorithm and I am nut sure exactly how to do it. Thanks in advance
I want to substract a couple of dates from todays exact date and time =NOW() and get the number of years, months and days that have passed since then.
But in some cases I get a negative number, which is in theory correct, but is there a way to avoid a - 4 and write it off as day 26 of the previous month or something along these lines? I need it to be an excel algorithm and I am nut sure exactly how to do it. Thanks in advance