Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

Date function returns #NUM!

All,

I need some help sorting out a problem with dates.

In G8: 12/31/1995 (serial value of: 35064)
G9, has the formula: =DATE(YEAR(G8),MONTH(G8)+2,1)-1 and yields #NUM!
(the purpose of the formula is to give me the last day of the next
month)

If I copy these two cells into a new workbook, I get the desired,
1/31/1996.

What could be causing this erratic behavior with my excel? The
workbook that I am modifying was created originally in Excel '97

Thanks!

Jonathan

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
date format and the RIGHT function	Rich Hayes	Excel Worksheet Functions	2	December 19th 05 12:29 PM
How do I use the concatenate function to add a date into a sentenc	Ken Janowitz	Excel Worksheet Functions	6	December 13th 05 10:41 PM
workday date function	sjayar	Excel Worksheet Functions	3	November 11th 05 05:15 PM
NETWORKDAYS - Multiple Date Selection	Annabelle	Excel Discussion (Misc queries)	3	October 4th 05 07:04 PM
Date function	Dee	Excel Worksheet Functions	2	July 13th 05 03:32 PM

All times are GMT +1. The time now is 02:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us