hi thanks for the reply i tried it and sadly didnt work, i then tried using the weekday formula which i didnt know about instead of using format 'dddd' of my dates and seeing if that works... and it did :D thanks a bunch