You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have one cell that has the total of recurring monthly charges and I have another cell where I want to have that total times the number of months that have passed in this current fiscal year. So it will update with time. How to do this?
Mac Pro
Hi Brian,
Perhaps this, using the DATEDIF function.
In the Months table, type the date of the start of the fiscal year in A2
B2 =TODAY()
C2 =DATEDIF(A2,B2,"M") and is the multiplier for Table 1 column A
Hide columns B and C in the Months table
Regards,
Ian.
Hi Brian,
Perhaps this, using the DATEDIF function.
In the Months table, type the date of the start of the fiscal year in A2
B2 =TODAY()
C2 =DATEDIF(A2,B2,"M") and is the multiplier for Table 1 column A
Hide columns B and C in the Months table
Regards,
Ian.
Thanks. Perfect. I did get the todays date by just writing =TODAY and I didn't add the ()
Thanks again.
monthly times current number of months
