If formula showing date
Solved/Closed
simeonmein
Posts
2
Registration date
Wednesday October 9, 2013
Status
Member
Last seen
October 9, 2013
-
Oct 9, 2013 at 05:28 AM
simeonmein Posts 2 Registration date Wednesday October 9, 2013 Status Member Last seen October 9, 2013 - Oct 9, 2013 at 02:56 PM
simeonmein Posts 2 Registration date Wednesday October 9, 2013 Status Member Last seen October 9, 2013 - Oct 9, 2013 at 02:56 PM
Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in cell j2
PROBLEM IS IT CHANGES THE DATE EVERY DAY! I need a formula that will enter todays date and keep it untill the value in d2 changes(but it won't).
Any help will be greatly appriciated
PROBLEM IS IT CHANGES THE DATE EVERY DAY! I need a formula that will enter todays date and keep it untill the value in d2 changes(but it won't).
Any help will be greatly appriciated
Related:
- If formula showing date
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 9, 2013 at 02:52 PM
Oct 9, 2013 at 02:52 PM
Simoneonmein, Good afternoon.
Using function TODAY() you obtain a dynamic date. Always.
There are only two ways to obtain a fixed date depending on other situation.
1ª - You TYPE manually the date.
2ª - You use VBA or MACRO to input the date at the desired cell.
I hope it helps.
Using function TODAY() you obtain a dynamic date. Always.
There are only two ways to obtain a fixed date depending on other situation.
1ª - You TYPE manually the date.
2ª - You use VBA or MACRO to input the date at the desired cell.
I hope it helps.
simeonmein
Posts
2
Registration date
Wednesday October 9, 2013
Status
Member
Last seen
October 9, 2013
Oct 9, 2013 at 02:56 PM
Oct 9, 2013 at 02:56 PM
Thank you, but I managed to use a simple way. Where I give the textboxes commands to go, I gust simply added: ".offset(0, 8) = date" at the end and works every time.
Thanx
Thanx
