| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Suggestions requested for vacation planning Excel spreadsheet
I have a cell in a spreadsheet that contains a number of vacation
days. I would these vacation days to turn to zero in the same cell after June 30th. I'm VB illiterate...is there an IF, THEN formula (or any other) that would work for this? |
|
#2
|
|||
|
|||
|
=if(today()DateValue("Jun 30, 2005"),0,current formula)
-- Regards, Tom Ogilvy "echo144000" wrote in message om... I have a cell in a spreadsheet that contains a number of vacation days. I would these vacation days to turn to zero in the same cell after June 30th. I'm VB illiterate...is there an IF, THEN formula (or any other) that would work for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Spreadsheet as an E-mail attachment | Excel Discussion (Misc queries) | |||
| How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. | Excel Discussion (Misc queries) | |||
| how do i import a picture or drawing into an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
