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
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
- Excel grade formula - Guide
- Credit summation 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
