Formula to add big number of day to date in excel sheet [Solved/Closed]

Report
Posts
1
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 17, 2014
-
 mgkimmel -
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

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4026 users have said thank you to us this month

Dear Marcilio
Many thanks for your assist, really I appreciated ,
Regards
Rename
Did exactly what I needed. Thank you!