Help with excel
Solved/Closed
Hello,
does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formula to have the next month be 11/28/2011 then 12/28/2011. I want to set it up in a way which i just have to end the first date.
Thanks
does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formula to have the next month be 11/28/2011 then 12/28/2011. I want to set it up in a way which i just have to end the first date.
Thanks
Related:
- Help with excel
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Nov 29, 2011 at 12:42 PM
Nov 29, 2011 at 12:42 PM
Hi,
Try this formula (DateCell is the cell containing the first date) :
= EDATE(DateCell,1)
Regards
Try this formula (DateCell is the cell containing the first date) :
= EDATE(DateCell,1)
Regards
Nov 29, 2011 at 03:55 PM