This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Lol yes, I am not neat with my formulas and usually just keep throwing
stuff in there til they work. Thanks for cleaning that up! I also came
up with the formula below that ensures that the month number is
dependent on the anniversary day of the mont...
This seems to be working well for me for calculating the days portion:
if(((hour(today()-date(concatenate((month(EOMONTH(TODAY(),
-1))),"/",(day([DOB])),"/",(year(EOMONTH(TODAY(),
-1)))))))/24)<(hour(today()-(EOMONTH(TODAY(), -2) +
DAY(TODAY())))/24)...