EXCEL worksheet
I NEED TO ADD 90 DAYS TO A DATE IN A CELL IN EXCEL
|
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 |
HEY THAT WAS FAST.
THANKS, AUDI |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com