Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working out the date
Somebody please help me as this is driving me insane!
What i would like excel to do is automatically input the date that is 6 weeks after the date i input! For example, in column 1 i put the date 01/01/2006, in column 2 i would like the date 6 weeks after that to automatically appear, which would be 12/02/2006 Is this type of thing possible to do on excel? And if it it will the computer undertsand weeks or will it have to be in days (so 6 weeks would be 42 days). I hope someone can shed some light on this for me. If you need any further clairification then please ask. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working out the date
If you put your date in A1, enter this formula in B1:
=IF(A1="","",A1+42) Format this cell as a date in the way you wish and copy down the column - if you haven't entered a date in column A then the column B will be blank. Hope this helps. Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working out the date
you could try
1/01/2006 12/02/2006 both cells formatted to date, date typed into first cell , formula in second cell = =A1+42 and your done. -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "Spiller" wrote in message ... Somebody please help me as this is driving me insane! What i would like excel to do is automatically input the date that is 6 weeks after the date i input! For example, in column 1 i put the date 01/01/2006, in column 2 i would like the date 6 weeks after that to automatically appear, which would be 12/02/2006 Is this type of thing possible to do on excel? And if it it will the computer undertsand weeks or will it have to be in days (so 6 weeks would be 42 days). I hope someone can shed some light on this for me. If you need any further clairification then please ask. Thank you |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working out the date
Thank you so much Pete! My headache has now disappeared!!!
"Pete_UK" wrote: If you put your date in A1, enter this formula in B1: =IF(A1="","",A1+42) Format this cell as a date in the way you wish and copy down the column - if you haven't entered a date in column A then the column B will be blank. Hope this helps. Pete |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working out the date
Thanks for the feedback. Glad to hear you are feeling better!
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Date sorting not working? | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Convert 20050118 to a working date field | Excel Worksheet Functions |