Adding a date to calender to automatially generate another date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you add a date into an Excel calender and have it automatically
generate a later date in the calender year automatically.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Calendar to Worksheet 9
Generating dates from a calender week value 4
Add one year in second combobox in vba 0
Counting dates with specific criteria 1
How to write XIRR formula on excel using different Year basis than 365. 5
convert date to yyyyddd format 2
Insert calender 8
Making Excel build a Gant Chart 1

Back
Top