Is there a formula that can do this in a calculated column:

{Sold YTD} divided by the number of months since April 1st

For example if we sold 100 so far this year and based on the date, we've only completed 2 months this fiscal year, then we've sold on average 50 per month.

Hi Susan,

Sounds reasonable to do.

First calculate the number of months since April 1:
MONTH(TODAY()) - 4 + 1 (4 is the month of April, and add 1 to correctly calculate the number of months)

Or if you need to consider when this is printed in January 2013 and include the year:
YEARL(TODAY()) - 2012 + MONTH(TODAY()) - 3

Then do the division:
{Amt Sold YTD} / (YEARL(TODAY()) - 2012 + MONTH(TODAY()) - 3)

And you could use the FISCALSTART() function to determine the first day of the fiscal year (as defined in your GridView Defaults) to have a formula calculate the month and year instead of hard-coding 2012 and +4:

{Amt Sold YTD} / (YEARL(TODAY()) - YEARL(FISCALSTART()) + MONTH(TODAY()) - MONTH(FISCALSTART()) +1)

Don't you also need to multiply the year difference by 12 months/year?

Oops - yes, the Year difference part should be multiplied by 12. Too soon after AOC...

Support:
Whereas for Wally, AOC seems to have improved his programming skills! Who knew?