Date counting with user inputsSolved/Closed

Question

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.  :-)



Configuration: Windows / Chrome 34.0.1847.131

TrowaD · Answer

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

RayH · Answer

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 · Answer

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.

Date counting with user inputs

3 responses

Similar discussions

Subscribe To Our Newsletter!