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

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?