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
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
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
Related:
- Formula to add big number of day to date in excel sheet
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Sheet right to left in google sheet - Guide
- How to add @ in laptop - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 17, 2014 at 07:06 PM
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
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
Jul 18, 2014 at 09:54 AM
Many thanks for your assist, really I appreciated ,
Regards
Rename
Apr 4, 2015 at 12:53 PM