Excel (Rounding down numbers)

  Noldi 19:10 06 Aug 2005

I have a excel sheet that gives me the week no on a monday but later in the week it becomes eg 31.7. I am looking for a formula that will keep that at 31 until monday of the 32nd week. if you format it as data with no decimal places then it rounds up after .4

  VoG II 19:25 06 Aug 2005

With a number in A1


  Noldi 19:34 06 Aug 2005

I thought it was simple but had a brain fade.

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?