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

%3CLINGO-SUB%20id%3D%22lingo-sub-2756953%22%20slang%3D%22en-US%22%3ECalculation%20based%20on%20Month%20and%20Year.....Todays%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2756953%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20formula%20that%20does%20a%20calculation%20based%20on%20Todays%20date.%26nbsp%3B%20It%20decides%20if%20the%20install%20date%20was%20last%20month%20based%20on%20todays%20date%20to%20do%20the%20calculation.....if%20not%20then%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20realised%20i%20need%20it%20to%20based%20it%20also%20on%20the%20year.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(MONTH(%5BInstall%20date%5D)%3DMONTH(%5BReport%20Date%5D)-1%2CSUM(%5BDays%20to%20bill%5D%2F%5BDays%20in%20the%20Month%5D)%2C1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20how%20i%20would%20tell%20it%20to%20base%20it%20on%20MONTH%20and%20YEAR%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20just%20add%20the%20year%20in%20which%20needs%20to%20match%20the%20year%20in%20install%20date%20and%20report%20date%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2756953%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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