Calculation based on Month and Year.....Todays date

New Contributor

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?

0 Replies