Excel (Rounding down numbers)

  Noldi 19:10 06 Aug 05

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 05

With a number in A1


  Noldi 19:34 06 Aug 05

I thought it was simple but had a brain fade.

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

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos