Entering days in spreadsheet
ONe way:
Dates in XL are just integer offsets from a base date, so
A1: <order date
B1: =A1+28
Format B1 as a date.
In article ,
Dennis1188 wrote:
Column A has €śOrder Date€ť Column B has €śDue Date€ť. Is there a way for me to
enter a date in column A and have B automatically show the date four weeks
later?
|