| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact Date
Hi!
Sorry if this question is posted twice. I tried to post before, it didn't appear in the list of question for long time , so i am posting it again. I want to know the way to find on which day , month and year will it be just 5 years from today. Suppose A1 = 8-Aug-2009, what is the way to know on which day, month and year will it be 5 years from today? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To get exact Date
If you want 5 years from today, then
=DATE(YEAR(TODAY())+5,MONTH(TODAY()),DAY(TODAY())) but that will give a different answer tomorrow. If you want 5 years from a date in A1, then =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) -- David Biddulph "deepak" wrote in message ... Hi! Sorry if this question is posted twice. I tried to post before, it didn't appear in the list of question for long time , so i am posting it again. I want to know the way to find on which day , month and year will it be just 5 years from today. Suppose A1 = 8-Aug-2009, what is the way to know on which day, month and year will it be 5 years from today? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To get exact Date
Hi
=DATE(YEAR(A1)+5,Month(A1),DAY(A1)) -- Regards Roger Govier "deepak" wrote in message ... Hi! Sorry if this question is posted twice. I tried to post before, it didn't appear in the list of question for long time , so i am posting it again. I want to know the way to find on which day , month and year will it be just 5 years from today. Suppose A1 = 8-Aug-2009, what is the way to know on which day, month and year will it be 5 years from today? Thanks __________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________ The message was checked by ESET Smart Security. http://www.eset.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
| Line Chart-EXACT End Date | Charts and Charting in Excel | |||
| Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
| How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
| Sorting by date when the date isn't exact | Excel Discussion (Misc queries) | |||
Linear Mode
