Date counting with user inputs

Solved/Closed
Plastic_Cup_of_Stars Posts 6 Registration date Saturday March 29, 2014 Status Member Last seen July 12, 2014 - May 14, 2014 at 11:40 PM
Plastic_Cup_of_Stars Posts 6 Registration date Saturday March 29, 2014 Status Member Last seen July 12, 2014 - May 15, 2014 at 12:32 PM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
May 15, 2014 at 11:11 AM
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
Plastic_Cup_of_Stars Posts 6 Registration date Saturday March 29, 2014 Status Member Last seen July 12, 2014
May 15, 2014 at 12:32 PM
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