Sep 16 2021 09:18 AM
Hi everyone,
I have a formula that does a calculation based on Todays date. It decides if the install date was last month based on todays date to do the calculation.....if not then 1
i realised i need it to based it also on the year.
=IF(MONTH([Install date])=MONTH([Report Date])-1,SUM([Days to bill]/[Days in the Month]),1)
Anyone know how i would tell it to base it on MONTH and YEAR?
So just add the year in which needs to match the year in install date and report date?