ExcelBanter - Suggestions requested for vacation planning Excel spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Suggestions requested for vacation planning Excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/1842-suggestions-requested-vacation-planning-excel-spreadsheet.html)

echo144000

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?

Tom Ogilvy

=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?

All times are GMT +1. The time now is 05:47 AM.