Help with Excel Date formula

Microsoft Excel 2002 (full product)
January 29, 2010 at 03:54:37
Specs: Windows XP

I am looking to see if there is a formula where I have a date in cell B1, and the formula results in the date in C1 being 7 days later than B1, and the date in cell D1 is 14 days later than that in B1. Also, in a reversal, so the date in A1 is 7 days prior to that in B1....

Can anyone help me please?



Edit: Subject line edited by Office moderator to be more specific.

See More: Help with Excel Date formula

Report •

January 29, 2010 at 05:25:54
Format your 4 columns as a Date.

You are entering a date in B1 so
in A1 use =B1-7
In C1 use =B1+7
In D1 use =B1+14


Report •
Related Solutions

Ask Question