If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#VALUE in Date calc
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, |
#2
|
|||
|
|||
#VALUE in Date calc
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 On Mar 5, 8:38 pm, Martha wrote: 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, |
Thread Tools | |
Display Modes | |
|
|