GSCaupling
Technical User
Is there a function or addin for Excel (2013) that returns a unique number for each month, similar to how days are counted from 1/1/1900? I don't mean the Month function that returns "6" for June no mater what year it is. I need every month to have a unique, consecutive number.
For example, today, 6/23/2014, is DayNumber 41813. I'm looking for something that identifies January 1900 as Month #1, June 2014 as Month #1374, next month as 1375, etc.
Any thoughts?
Thanks,
GS
[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]