ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate 30 days later from a date (https://www.excelbanter.com/excel-worksheet-functions/38192-how-do-i-calculate-30-days-later-date.html)

SYH

How do I calculate 30 days later from a date
 
I'm trying to calculate 1/30/05 to 30 days later from that date.


Biff

Hi!

=DATE+30

A1 = 1/30/05

=A1+30

Biff

"SYH" wrote in message
...
I'm trying to calculate 1/30/05 to 30 days later from that date.





All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com