• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel question - help calculating dates

I

icejunkie

Platinum Member
Hi all,
I need to do 2 things:
1) Type in a date in one cell and in another cell have it output that date adding 18 months forward.
2) take the date after 18months were added and add any number of days I want(ie. 13, 165, 219, 54,etc..)and have it output the date with those number of days added.

please help!

thanks in advance 🙂
 
If you've installed the Analysis Toolpack, then you can use the function EDATE

EDATA Function Help

Once you've generated the +18 months date, then just add the number of days you want to generate the correct date.

Assume the original date is in A1.
A2: EDATE(A1,18) would add 18 months to it and fix the date correctly (based on the month).
A3: =A2+41 would add 41 days to the date in A2.

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top