|
| 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
March 5th, 2007, 08:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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
March 5th, 2007, 08:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 | |
|
|
Linear Mode
