| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell is blank automatically enter today's date in the same cell
Can someone please help with the following? I have a blank cell in say M10 which when a date is typed into it is used in another formula which counts all those entries before that date which are overdue. What I would like to happen is if the cell is blank then todays date is automatically entered. I have tried the following formula but all I get is the word FALSE and I need todays Date. Can someone out there please assist?
=IF(ISBLANK(""),TODAY()) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically enter today's date as a static entry in Excel | Excel Discussion (Misc queries) | |||
| Can I automatically have a cell enter todays date + 45 dyas | Excel Discussion (Misc queries) | |||
| to enter today's date if a cell is blank | Excel Worksheet Functions | |||
| Automatically enter today's date as a static entry | Links and Linking in Excel | |||
| Automatically enter today's date as a static entry | Excel Worksheet Functions | |||
Threaded Mode
