Mod function
 

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)

Mod function
 

=Month(1/1/1900) would extract 1 from 1/1/1900, etc.

Dave
--
Brevity is the soul of wit.


"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)

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)

Mod function
 

Is this homework? Try this
=MOD(H3-1,12)+1
and think why it works
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Brad" wrote in message
...
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)

Mod function
 

Thanks - Tuesday morning after a three day weekend - shoulda seen that one
myself

"Toppers" wrote:

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)

Mod function
 

Thanks - not homework - shoulda seen this one myself.

"Bernard Liengme" wrote:

Is this homework? Try this
=MOD(H3-1,12)+1
and think why it works
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Brad" wrote in message
...
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)

Mod function
 

I don't remember saying thanks - so Thank you.

"Toppers" wrote:

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)

Mod function
 

Appreciate the feedback.

"Brad" wrote:

I don't remember saying thanks - so Thank you.

"Toppers" wrote:

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)