Hi,
I'm using the formula =G2-(IF(WEEKDAY(G2)>1,WEEKDAY(G2)-2,6)) to convert a date to the first day of that week (Monday), kindly suggested by Schwarzmanne.
I want to amend this to avoid the 'negative dates or times are displayed as ####' error that appears if any cells are blank.
Anyone help?
Thanks,
Doug.
I'm using the formula =G2-(IF(WEEKDAY(G2)>1,WEEKDAY(G2)-2,6)) to convert a date to the first day of that week (Monday), kindly suggested by Schwarzmanne.
I want to amend this to avoid the 'negative dates or times are displayed as ####' error that appears if any cells are blank.
Anyone help?
Thanks,
Doug.