Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding 28 days to a date
Hi
I was wondering if anyone knew of a way of typing a date for example 01/01/07 and then when you drag the crosshaire into the next cell instead of it saying 02/01/07 it adds 28 days on to it so it says 28/01/07 and so on Regards Joel -- N/A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding 28 days to a date
Instead of dragging just enter "=a1+28" into the next cell. (assuming
the first date is in cell a1) See xl help for times and dates. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding 28 days to a date
Joel wrote on Wed, 10 Oct 2007 08:22:00 -0700:
J I was wondering if anyone knew of a way of typing a date for J example 01/01/07 and then when you drag the crosshaire into J the next cell instead of it saying 02/01/07 it adds 28 days J on to it so it says 28/01/07 and so on Off the top of my head, suppose the date is in A2, make a1 =a2-28, cut and special paste its value into A1, set A2=a1+28. Then pulling the tab will do the trick. Not very elegant but it works. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding business days to a date | Excel Worksheet Functions | |||
My discovery on adding months and days to a date! | Excel Worksheet Functions | |||
problems adding days to a date | New Users to Excel | |||
Adding # of days to a date | Excel Worksheet Functions | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) |