ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   EXCEL worksheet (https://www.excelbanter.com/excel-worksheet-functions/36119-excel-worksheet.html)

audi

EXCEL worksheet
 
I NEED TO ADD 90 DAYS TO A DATE IN A CELL IN EXCEL

Matt Lunn

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


audi

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