Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a date to calender to automatially generate another date?
How do you add a date into an Excel calender and have it automatically
generate a later date in the calender year automatically. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a date to calender to automatially generate another date?
Hi Crystal
Excel stores its date values internally as a numeric value. Hence, to generate a future date from any given date, you can in the simplest instance just add a number of days. With cell A1 containing 01 Jan 2006 B1 =A1+1 will give 02 Jan 2006, =A1+10 will give 11 Jan 2006 =DATE(YEAR(A1),MONTH(A1)+1,1) will give the result 01 Feb 2006 =DATE(YEAR(A1),MONTH(A1)+2,1) will give 01 Mar 2006 Note the general format of =DATE(year,month,day) =DATE(2006,4,1) will give 01 Apr 2006 Using 0 as the day value, will give th last day of the previous month so =DATE(2006,4,0) will give 31 Mar 2006 I hope this information will get you dtarted. -- Regards Roger Govier Crystal Long <Crystal wrote How do you add a date into an Excel calender and have it automatically generate a later date in the calender year automatically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours to a date | Excel Worksheet Functions | |||
Generate an Absolute Date in a Cell | Excel Worksheet Functions | |||
Using date to generate new workbook | Excel Worksheet Functions | |||
is there a formula to generate a calendar month date rather than . | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |