Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Add 365 days to an existing date in Excel.
- Thread starter marine22
- Start date
SkipVought
Programmer
Hi,
The short answeris if your date is in A1, then =A1+365.
Date/Time is just a number beginning with 1/1/1900. Each day is a unique integer --
Today is 37942
The date and time just a few seconds ago was 37942.3748
The date/tiem is FORMATTED to look like you want it to look.
Skip,
Skip@TheOfficeExperts.com
The short answeris if your date is in A1, then =A1+365.
Date/Time is just a number beginning with 1/1/1900. Each day is a unique integer --
Today is 37942
The date and time just a few seconds ago was 37942.3748
The date/tiem is FORMATTED to look like you want it to look.
Skip,
Skip@TheOfficeExperts.com
do you really want to add 365 days or a year ???
For 365 days
=date+365
for a year, it gets more complex as you have to take 28/29 30/31 day months into the equation....
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
For 365 days
=date+365
for a year, it gets more complex as you have to take 28/29 30/31 day months into the equation....
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
xlbo,
I would think that 365 days would add a year in every case except for a leap year.
marine22,
This is the other way to do this if you want excel to add the year for you. This assumes your date is in a1.
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
Hope that helps!
I would think that 365 days would add a year in every case except for a leap year.
marine22,
This is the other way to do this if you want excel to add the year for you. This assumes your date is in a1.
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
Hope that helps!
xlbo,
Fair enough on the 28/29 day point I am sure we are on the same wavelength there. My comment came from your reference to adjustments needed for 30/31 day months as these are static.
marine22,
FYI, here are the results from the two methods:
A1 =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) =A1+365
1/1/2000 1/1/2001 12/31/2000
1/1/2001 1/1/2002 1/1/2002
1/1/2002 1/1/2003 1/1/2003
1/1/2003 1/1/2004 1/1/2004
Hope that helps!
Fair enough on the 28/29 day point I am sure we are on the same wavelength there. My comment came from your reference to adjustments needed for 30/31 day months as these are static.
marine22,
FYI, here are the results from the two methods:
A1 =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) =A1+365
1/1/2000 1/1/2001 12/31/2000
1/1/2001 1/1/2002 1/1/2002
1/1/2002 1/1/2003 1/1/2003
1/1/2003 1/1/2004 1/1/2004
Hope that helps!
SkipVought
Programmer
Problem is, marine22, that your asked for date plus 365 and NOT date plus 1 year.
As an analyst, I would conduct a detailed question and answer session with my client as to what BUSINESS CASE they were attempting to solve. As you can see, the answers when it comes to dates can have some caveats.
Skip,
Skip@TheOfficeExperts.com
As an analyst, I would conduct a detailed question and answer session with my client as to what BUSINESS CASE they were attempting to solve. As you can see, the answers when it comes to dates can have some caveats.
Skip,
Skip@TheOfficeExperts.com
vanvb - true - we use rolling periods a lot and the whole "how many days in a month" crops up a lot so it's usually the 1st thing I think about whenever I see a question on adding dates.
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Status
Similar threads
- Locked
- Question