- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Calling MS Excel gurus
Posted on 1/1/18 at 6:47 pm
Posted on 1/1/18 at 6:47 pm
Need to add 42 days to a date in another cell but can't to go past 1 calendar month
Example
Dec 25, 2017 + 42 days will give me Feb 5, 2018. But I can't have a date past one calendar month so the last date would need to be Jan 31, 2018. Any suggestions?
3
Posted on 1/1/18 at 6:56 pm to aib799
Use a nested IF
Posted on 1/1/18 at 7:18 pm to ODP
Trying but having trouble referencing past 1 month
Posted on 1/1/18 at 7:23 pm to ODP
I’d need to test out a few formulas with Excel open to do this one. I don’t use the date functions that often but a number of them exist.
It will be some kind of Nested IF formula with a reference to a TODAY() or NOW() formula.
It will be some kind of Nested IF formula with a reference to a TODAY() or NOW() formula.
Posted on 1/1/18 at 7:46 pm to aib799
Let A1 hold the date, and...
=MIN(A1+42,EOMONTH(A1,1))
=MIN(A1+42,EOMONTH(A1,1))
Posted on 1/1/18 at 7:57 pm to aib799
30 days from the current date?
Posted on 1/1/18 at 8:43 pm to Spock's Eyebrow
Never heard of EOMONTH() but I will definitely use it sometime in the future. 
Posted on 1/1/18 at 9:09 pm to lynxcat
I was going to use something like DATE(YEAR(A1),MONTH(A1)+2,0), but EOMONTH is definitely easier. Sometimes it pays to look at the Help file. 
Posted on 1/1/18 at 10:49 pm to Spock's Eyebrow
Use EOM all the time for financial models
Posted on 1/2/18 at 8:49 am to Spock's Eyebrow
quote:
Let A1 hold the date, and...
=MIN(A1+42,EOMONTH(A1,1))
Awesome, thanks for the help
Posted on 1/2/18 at 9:44 am to barry
EOM is legit...Use that one all the time.
I’m also fond of using weekday and then an if statement to skip weekend dates on a weekly report I run through excel
I’m also fond of using weekday and then an if statement to skip weekend dates on a weekly report I run through excel
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News