Date counting with user inputs

Solved/Closed
Report
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014
-
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014
-
Hello,

I'm looking for a date counting formula between two dates, where the user defines the total number of days, and Excel will tell them which end date they need.

Example:

A1 = 11/05/13 (user will enter the start DATE of their choice)

B1 = 181 (user enters a random number of days forward from the date in A1)

C1 = Excel shows the calendar DATE that will be A1 (date) + B1 (181 days).


Thank you, in advance, for all of your help. :-)



3 replies

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Plastic_Cup_of_Stars,

Not sure what your question is?

If C1 is not giving you the desired answer then make sure the cell is formatted properly.

Best regards,
Trowa

0
Yes, not sure where the problem lies since you already have given the formula.
In C1, its simply =A1+B1

Of course as TrowaD points out the format of C1 should be set to display dates as should A1. B1 should be number (with zero decimals places) or just General.
0
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014

I feel really silly, you guys. I didn't even think about making this a simple addition equation, and formatting the answer cell to a date. In my mind, it needed to be a much more complicated formula--I don't know what I was thinking. Thank you for your help. Your suggestions worked great.
0