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

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Inside the iMac Pro - Apple's most powerful Mac yet

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?