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 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

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.
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.