Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the feedback. Be sure to indicate by checking the YES box below
that your question has been answered :) -- ** John C ** "frykid50" wrote: thanks for all the replies...they were all helpful. oh and i put the wrong date in (12/10/20033). that's what happens when trying to do 2 things at once! "John" wrote: Sorry 25 years will bring you to Jan/31/2033 "John" wrote in message ... To answer your question "Yes" But I don't know where you're getting that answer ( 12/10/2033 ) 35 years will bring you to Jan/31/2033 including 7 leap years Regards John "frykid50" wrote in message ... I have a date (1/31/08) and I need to add 25 years to it. I know the formula to do this (=Date(YEAR(A4)+B4,MONTH(A4),DAY(A4)) where the answer is 12/10/2033. No problem. However, does this account for a leap year? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |