does anyone know the formula to: copy a date from one cell to another but backdating it 6 weeks? for example, I put 01/06/04 in C2, and the formula puts 20/08/04 in D2?
formala for copying a date into another cell but backdated 6 weeks?
-
-
=C2-42
Make sure D2 is Date-Formatted
Edit: I assume you meant D2 woud be 20/04/2004 (6 weeks before 1/06/2004
)
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!