Excel Adding Date
I have a form that uses an if statement to see if a cell is blank. If not, it
adds the date using TODAY. The problem is the date changes when the system date changes. Is there a way to insert the date, but have it stay fixed when the system date changes? |
Excel Adding Date
if you do a worksheet(1).Range(a1).value2 = Today() then is should remain
assuming you never have the if statement true. Which it shouldn't being you will have data in the Cell.... This is one way "Jason Southco" wrote in message ... I have a form that uses an if statement to see if a cell is blank. If not, it adds the date using TODAY. The problem is the date changes when the system date changes. Is there a way to insert the date, but have it stay fixed when the system date changes? |
Excel Adding Date
Would NOW( ) work? |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com