Posted to microsoft.public.excel.worksheet.functions

Martha

external usenet poster

Posts: 32

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumproduct date calc.	Todd	Excel Worksheet Functions	4	November 16th 06 03:12 AM
rounddown with date calc?	Ltat42a	Excel Discussion (Misc queries)	5	January 5th 06 08:04 PM
Calc End Date	OCD Cindy	Excel Worksheet Functions	2	September 18th 05 09:52 PM
Date Calc. HELP	Jerry Kinder	New Users to Excel	7	May 20th 05 05:06 AM
calc constant date from variable date & return with ability to rn.	SusieQ'sQuest	Excel Worksheet Functions	1	November 9th 04 08:51 PM

All times are GMT +1. The time now is 02:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us