Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel, I need a date math formula...
I need to create a forula that uses a date in a cell and adds five years to
that date and returns that answer. Can this be done? Thanks, Lisa |
#2
|
|||
|
|||
Hi Lisa,
Try: =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) --- Regards, Norman "Lisa" wrote in message ... I need to create a forula that uses a date in a cell and adds five years to that date and returns that answer. Can this be done? Thanks, Lisa |
#3
|
|||
|
|||
=DATE(YEAR(cell)+5,MONTH(cell),DAY(cell))
Regards, Peo Sjobom "Lisa" wrote: I need to create a forula that uses a date in a cell and adds five years to that date and returns that answer. Can this be done? Thanks, Lisa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
Repeating formula in Excel | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |