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