thorpyuk
Well-known Member
- Joined
- Mar 14, 2006
- Messages
- 1,453
Hiya,
I have the following formula:
="W/C "& TODAY()-WEEKDAY(TODAY(),2)+1
Which will calculate the day of last week. However i do not know how to show this in the proper format. At the moment it returns:
W/C 39636
Because the cell sees text as well as a date value i cannot format the cell as a date :/
Can anyone help? Thanks
I have the following formula:
="W/C "& TODAY()-WEEKDAY(TODAY(),2)+1
Which will calculate the day of last week. However i do not know how to show this in the proper format. At the moment it returns:
W/C 39636
Because the cell sees text as well as a date value i cannot format the cell as a date :/
Can anyone help? Thanks