Forum Discussion

trevb's avatar
trevb
Icon for Advocate II rankAdvocate II
10 years ago

Number of Months between two dates

This seems like a really dumb thing to be asking.   I need to count the number of Months between two dates.  I can happily find out the number of days, but that doesn't help much as number of days ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

That data table should look like:

 

start                  end                Years                Days Left             StartMonth               EndMonth              Months

1/1/2015           1/29/2016      1                        27.75                   1                               1                            12

1/29/2015         1/6/2016        0                        342                      1                               1                            0

6/12/2014          7/2/2016       2                        20.5                     6                               7                            25