MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Diane Crissey on September 19, 2000 8:05 AM

How do I write a formula which would look at a date in another cell and would insert a date minus 5 or 10 days.

Posted by Celia on September 19, 0100 5:02 PM

If the date is in A1 :-
=A1-5 or =A1-10