Mod function
Try:
=MOD(H3-1,12)+1
"Brad" wrote:
I'm doing a date calculation where by 1 is January 1900, 2 is February 1900,
... 1281 is September 2006. I want to extract the month from the number.
The following works - but is there a better way (where I don't have to use an
IF)?
=IF(MOD(H3,12)<0,MOD(H3,12),12)
|