Calculate date 4 weeks from the day i enter

[Frankiemillion]

Rookie Excellian and wanting to know how to make a cell calculate the date 4 weeks from the date i supply in another cell... hope thats clear bout what i need...

Any help would be awesome sorry if this is basic...

[daddylonglegs]

In Excel 1 day = 1 so to add 4 weeks to a date you just add 28, e.g. if your date is in A1 just use the formula

=A1+28

[Frankiemillion]

In Excel 1 day = 1 so to add 4 weeks to a date you just add 28, e.g. if your date is in A1 just use the formula

=A1+28

So simple yet so helpful... Is there anyway for me to protect that formula so i can override it but if i delete the date i put in myself it will use the formula again???

[Frankiemillion]

So simple yet so helpful... Is there anyway for me to protect that formula so i can override it but if i delete the date i put in myself it will use the formula again???

^^^ That isnt really important atm...

How can i get the cell showing the date plus 4 weeks to display nothinhg until i insert a date in the other celll... cause with that formula it says 28 till i put a date in...

[DanielCoates]

I know it's an old thread, and there's probably no need for a solution to the second problem, but this is how I check for a blank cell.

I would use the ISBLANK function '=IF(ISBLANK(A1),"",A1+28)' where A1 is the cell you wish to check