Posted to microsoft.public.excel.programming

inungh

external usenet poster

Posts: 33

DateSerial function

I would like to calculate rollong calendar from today in the loop.

For example, today is Dec/11/2008 and I need to get all informaiton 12
months before today. (from Dec/11/2007 to Dec/11/2008).

I just wonder can DateSerila do the job.

For example, DateSerial(MyYear, MyMonth - i, MyDay)

Will DateSerial changed the year if the month is minus number?

Your information is great appreciated,

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
Recreating the DateSerial()/Date() function	Conan Kelly	Excel Worksheet Functions	1	March 1st 08 04:43 AM
Recreating the DateSerial()/Date() function	Conan Kelly	Excel Programming	1	March 1st 08 04:43 AM
using dateserial in vb	mwam423	Excel Programming	3	June 14th 07 02:45 AM
DateSerial Troubles	rockerx	Excel Programming	1	March 14th 07 08:14 PM
Time/DateSerial Numeric Value	Jay	Excel Worksheet Functions	4	March 16th 05 03:34 AM

All times are GMT +1. The time now is 03:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us