Request for help : Monday + 1 = Tuesday (in formule)

Giganews Newsgroups
Subject: Request for help : Monday + 1 = Tuesday (in formule)
Posted by:  J.J.Erkamp (jerka…@hccnet.nl)
Date: Tue, 11 May 2004

Hi
Please help
Which formule can I use to get the next day in B1
For example:
A1 = Monday
B1 = formule A1 + 1 = Tuesday
or
A1 = Wednesday
B1 = formule A1 + 1 = Thursday

        A        B
1    Monday  (A1+1)

Regards

Hans

Replies