Formula to add big number of day to date in excel sheet

Solved/Closed
Renaming Posts 1 Registration date Thursday July 17, 2014 Status Member Last seen July 17, 2014 - Jul 17, 2014 at 06:48 PM
 mgkimmel - Apr 4, 2015 at 12:53 PM
Dear
Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC.
As example I want to add 120 or 180 days to date 30/4/2014. I need the result in date formula.
Looking froward to hearing from you ASAP.
Regards
Maher

1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jul 17, 2014 at 07:06 PM
Renaming, Good evening.

Try to use it:
A1 = 30/04/2014
B1--> = A1 + 120

Result --> B1 = 28/08/2014

If needed format B1 to Date

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
6
Dear Marcilio
Many thanks for your assist, really I appreciated ,
Regards
Rename
0
Did exactly what I needed. Thank you!
0