How to Resize Photos in Batch?: Troubleshooting:Apply Now() function only if cell is blank.

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.

Download Error Fixer (Free)

Hi,
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")
End If
End Sub
change the sheet name and cell to the required ones

If this post answers your question, please mark it as the Answer.
Mike H

Windows Restore

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.