jeudi 18 août 2016

Extract Month name from fiscal calendar date range

I am trying to extract the month name from a fiscal calendar date range. For example January 2016 has a date range of 12/29/2015- 02/01/2016; February 2016 has a date range of 02/02/2016- 02/29/2016; March 2016 has a date range of 03/01/2016- 03/28/2016; April 2016 03/29/2016- 05/02/2016...and so on. What formula can I use so it works for all months and it returns a simple "January 2016"?

Thank you for your help!

Aucun commentaire:

Enregistrer un commentaire