Hi,
I am looking for formula which gives me months which falling in 2019 year and months falling in 2019.
Like if my date start from 5/31/2018 and end date is 5/31/2019, then as only want months in only 2019 year hence my output will be 7 and blank in 2020.
Likewise if my start date is 5/31/2019 and end date is 5/31/2020 then in2019 my output will be 7 and in 2020 it will be 5.
Many thanks in advance
I am looking for formula which gives me months which falling in 2019 year and months falling in 2019.
Like if my date start from 5/31/2018 and end date is 5/31/2019, then as only want months in only 2019 year hence my output will be 7 and blank in 2020.
Likewise if my start date is 5/31/2019 and end date is 5/31/2020 then in2019 my output will be 7 and in 2020 it will be 5.
Many thanks in advance
Attachments

15.6 KB Views: 12