Excel formula to change a value every 2 weeks

B

Bobski

Hi there:confused:
I need a formula to make text in a cell change every 2 weeks. The text
in the cell should read 'do not change air con. units', but every other
week it should read 'change air con. units'.

If you can help I would be very greatful.
Thanks!
 
D

Dave Peterson

Maybe something like:

=IF(MOD(INT(A1/7),2)=1,"one week","other week")

This starts the week on a Saturday.
 
Top