Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EXCEL worksheet
I NEED TO ADD 90 DAYS TO A DATE IN A CELL IN EXCEL
|
#2
|
|||
|
|||
Hi
Assuming the date value is in Cell A1 you could use =DATE(YEAR(A1),MONTH(A1), DAY(A1)+90) A shorter version is = A1 +90 Thanks, Matt HTH, Matt "audi" wrote: I NEED TO ADD 90 DAYS TO A DATE IN A CELL IN EXCEL |
#3
|
|||
|
|||
HEY THAT WAS FAST.
THANKS, AUDI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i create a path to a worksheet from outside of excel | Excel Discussion (Misc queries) | |||
Excel worksheet linking | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |