Calculate date
 

I am setting up a spreadsheet, where the result of a function is a date to be
stored in J15, which is always a Saturday. How can I setup the preceding 6
cells to have the corresponding dates based on that Saturday?

In Excel, a date is the number of days since Jan 1, 1900. Date formats
display them in understandable form. Calculating new dates is just a matter
of adding or subtracting the appropriate number of days.

With your date in J15, the day before is simply =J15-1. Etc.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Anthony" wrote in message
...
I am setting up a spreadsheet, where the result of a function is a date to
be
stored in J15, which is always a Saturday. How can I setup the preceding 6
cells to have the corresponding dates based on that Saturday?