Afternoon:

I am doing a simple calc (Date cell-30days) but the Date column is only
partially completed and will be dynamic. How to get rid of the #VALUE that
is being returned on =AN3-30?

Also can I subtract 6 weeks from a date? If so, how? Thanks much,