Excel help

  User-CB94CED6-F3AA-42E7-8A286564F5DCBC14 11:04 27 May 2010
Locked

I have a cell (A49) which computes NOW() customised to give the month (say for May it would show "5"). If I have a formula in another cell as "=((A49/12)*172.5)/3600" but the value is not 5 but 40325.5. How can I get the displayed month value across?

  VoG II 11:50 27 May 2010

Try

=((MONTH(A49)/12)*172.5)/3600

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

5 best 3D model websites

iPhone 8 vs iPhone X

WhatsApp : comment lire vos messages sans que l’expéditeur le sache