#VALUE in Date calc

M

Martha

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,
 
P

Pete_UK

Perhaps the date cell AN3 does not contain a proper date - more like a
text value that looks like a date. Hence you can't subtract 30 from a
text value. I'm not sure what you mean by "partially completed".

Six weeks is 42 days, so you can subtract 42 from the date to get to 6
weeks earlier.

Hope this helps.

Pete
 
Top