Need a date range - ExcelBanter

Posted to microsoft.public.excel.programming

Chad[_3_]

external usenet poster

Posts: 32

Need a date range

Hi All,

I am trying to store todays date minus x amount of days. So I get todays
date with Date Function, format it to YYMMDD. Now my problem is, today is
the 12, so if I minus 2 weeks I get 80999, not 080929. So it drops my
leading zero and ignores the month

How do I maintain a date structure across month changes.

Thanks
Chad

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
Create a formula in a date range to locate a specific date - ecel	util	Excel Discussion (Misc queries)	0	February 19th 07 03:03 PM
copy date based on date -refer to date range	mindpeace[_4_]	Excel Programming	1	June 3rd 06 01:30 PM
Formula for determining if two date columns fall within specific date range	Igottabeme	Excel Worksheet Functions	2	April 21st 06 02:50 AM
Formula for determining if two date columns fall within specific date range	Igottabeme	Excel Discussion (Misc queries)	1	April 20th 06 10:03 PM
How to count dates within a certain range in a column with mutiple date range entries	Krisjhn	Excel Worksheet Functions	2	September 1st 05 01:59 PM

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

Menu

About Us