MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula


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

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