Hi,

I need unique number to identify each month in the calendar system.

The formula
'=VALUE(RIGHT(YEAR(DATEVALUE("1-04-2016")),2)&"0"&MONTH(DATEVALUE("1-04-2016")))'returns
the number I wanted for the current month.

This there any better way of doing this?

TIA
Ahmed

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus