Apply Now() function only if cell is blank.
Hi I'm trying to put in logic that will display the current date in a cell only if that cell is currently blank (it wont overwrite an existing date). I've tried things like "=IF(b1="",Now())" where b1 is the cell i want the date in, but that gives me
a circular reference error. This must be easy to do but I'm missing something. Any help would be appreciated. Thanks!
Keys to the Problem Apply Now() function only if cell is blank.
ALT+F11 to open VB editor.
Double click 'ThisWorkbook' and paste this in on the right
Private Sub Workbook_Open()
If Sheets("Sheet1").Range("B1") = "" Then
Sheets("Sheet1").Range("B1") = Format(Now, "DD/MM/YYYY")
change the sheet name and cell to the required ones
If this post answers your question, please mark it as the Answer.
- Click on the Start button on the Taskbar.
- Type "System Restore" (without quotes) in the Search box and hit Enter or,
- Click on System Restore (when you see System Restore pop up in the list of search results).
- Make sure the "Recommended restore" radio button is checked on the restore utility window.
- Click on Next and follow the instructions given.
Note: There is the option on the restore utility to select "Choose a different restore point". Unless you have a specific reason to select a different date and time than what Windows recommends, just select the recommended option stated in the steps above. If you choose to select another one, follow these steps:Click on that desired date and time, and Windows 7 will perform a scan for any affected programs in that restore point.
Once completed, click Next and follow the instructions given.
Once you have selected the restore point, your system will start the restoring process, after which you will have to restart the system.
Recommended Method to Repair the Problem: Apply Now() function only if cell is blank.:
How to Fix Apply Now() function only if cell is blank. with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Run it, and it will scan your computer. The junk files will be shown in the list.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.
Related: error message fsui.exe/ wlidcli.dll is missing
,Solution to Error: Excel: Automatic number generation
,Troubleshoot:i wanna change language of all windows in Windows 7 Home Premium
,Troubleshooting:IF Function, if the vendor ID in column A matches any of the vendor ID's in column F, I want 1099 to appear in column D. Error
,Fast Solution to Problem: ReadyBoost is not working properly in my computer
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),brclr.dll.mu_ Missing Error Fixer,How To Resolve Missing fin_myagtui.eng Problem,Corrupted f_0006ad File - How to Fix,nkebigvg.cpl Not Found Error Fixer,Corrupted olcontrols.ocx File - How to Fix
Read More: Troubleshooting:Amazon Unbox won't play video's \"error code 0xC00D2728\",Fast Solution to Error: Apps automatically change position when arranging apps in Groups,Any way to disable the \"slow performance\" nag \/ aero drop out? Tech Support,Troubleshooter of Error: Any way I can have pre-entered data populate subsequent cells in the same row based on a choice I make in the first cell? Without IF-Statements?,How to Resolve - Apparently my email on outlook express has been blocked by everyone. Can this happen??,After Windows Update CD/DVD drive does not work,After installing windows 7 to laptop the labels print out of line how can I fix it,After my computer sleeps the wireless always disconnects and will no reconnect,After signing into Pogo.com, I get a message" This tab has been recovered"....what does this mean and how do I fix it.....,All desktop icons changed to windows live and does not open