Hey people!
I have a small problem in Excel. In column A I have normal day to day dates but in column B I want to display the next Saturday that appears on or after the date in column A. For example starting with 25/01/03 (Saturday)
Col A Col B
-------- --------
25/01/03 25/01/03
26/01/03 01/02/03
27/01/03 01/02/03
28/01/03 01/02/03
and so on and so ...
Thanks in advance for any help or tips!
I have a small problem in Excel. In column A I have normal day to day dates but in column B I want to display the next Saturday that appears on or after the date in column A. For example starting with 25/01/03 (Saturday)
Col A Col B
-------- --------
25/01/03 25/01/03
26/01/03 01/02/03
27/01/03 01/02/03
28/01/03 01/02/03
and so on and so ...
Thanks in advance for any help or tips!