Hi Joel

When I do 8/7 my answer is 1.142857. Windows XP, Office 2003 sp2. It is
working ok today!

Wendy




"Joel" wrote in message
...
The code is right. Check the data on you PC to make sure your have the
right
date set. You should get 8/7 = 1.333 and the ceiling function should
round
up to 2.

"Wendy" wrote:

Hi

I have a formula to work out the week number and day per month..
C1 ="W"&CEILING(DAY(B1)/7,1)&TEXT(WEEKDAY(B1),"DDD") and B1=TODAY( )

It was working fine but today should be W2Mon and the formula gives
W1Mon.

Thanks

Wendy