Quote:
Originally Posted by James Ravenswood
Something like:
=IF(WEEKDAY(TODAY())=1,TODAY(),TODAY()+8-WEEKDAY(TODAY()))
|
Thanks James. but I couldn't get it to work. I tried putting A1 in the () behind the TODAY's in the formula and I got an error message. Am I missing something?