Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by LLawson
-
Excel formula - 1st of month following 30 days
In cell A1, I have the date 8/5/1991. I need to convert the date to the 1st of the month following 30 days. 1. Add 30 days I added 30 days to cell A1 and get 9/5/1991. 2. 1st of next month after 30 days But I need to some how round the date up to the next 1st of the month to show 10/1/1991...- LLawson
- Post #3
- Forum: Microsoft: Office
-
Excel formula - 1st of month following 30 days
I am trying to write a formula in excel that will convert a date to the 1st of the month following 30 days. Can anyone help me?- LLawson
- Thread
- Replies: 6
- Forum: Microsoft: Office
