| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
| Calculate age as of a given date | Excel Discussion (Misc queries) | |||
| Calculate age as of a date certain | Excel Discussion (Misc queries) | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
| Calculate date of birth in Excel | Excel Worksheet Functions | |||
Hybrid Mode
