Amend IF(WEEKDAY) formula to avoid negative dates error

[dunlopoil]

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.

 

[Richard Schollar]

Hi Doug

=G2-WEEKDAY(G2,3)

 

[barry houdini]

To avoid #### if G2 is blank you can use Richard's formula and format cell with formula as

dd/mm/yy;;

or amend to

=IF(G2="","",G2-WEEKDAY(G2,3))

 

[dunlopoil]

Thanks Richard and Barry.