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
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
Related:
- Date counting with user inputs
- Lg tv rename inputs - Guide
- Phpmyadmin access denied for user 'root'@'localhost' - Guide
- T mobile authorized user - Guide
- Sound card inputs - Guide
- Please enter built in hdd user password ✓ - Hard Drive & SSD Forum
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 15, 2014 at 11:11 AM
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
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.
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
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.