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