| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with auto-fill of dates
I have a form that tracks when various visits are to be done and when they
were completed. One column is a reassesment visit and that is based off of the consumer's start date (another column) and is to be completed 364 days later (another column for the date complete), and every year after that. I have it set to fill-in the visit date automatically, but it only shows it one year from the start date. How do I get it to show a visit that is due this year if the consumer started in 1995? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with auto-fill of dates
=DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1
"artemis1027" wrote: I have a form that tracks when various visits are to be done and when they were completed. One column is a reassesment visit and that is based off of the consumer's start date (another column) and is to be completed 364 days later (another column for the date complete), and every year after that. I have it set to fill-in the visit date automatically, but it only shows it one year from the start date. How do I get it to show a visit that is due this year if the consumer started in 1995? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with auto-fill of dates
And if a spot is left blank, how do I get it to not automatically fill-in?
"Sean Timmons" wrote: =DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1 "artemis1027" wrote: I have a form that tracks when various visits are to be done and when they were completed. One column is a reassesment visit and that is based off of the consumer's start date (another column) and is to be completed 364 days later (another column for the date complete), and every year after that. I have it set to fill-in the visit date automatically, but it only shows it one year from the start date. How do I get it to show a visit that is due this year if the consumer started in 1995? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with auto-fill of dates
=if(A1="","",DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1)
"artemis1027" wrote: And if a spot is left blank, how do I get it to not automatically fill-in? "Sean Timmons" wrote: =DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1 "artemis1027" wrote: I have a form that tracks when various visits are to be done and when they were completed. One column is a reassesment visit and that is based off of the consumer's start date (another column) and is to be completed 364 days later (another column for the date complete), and every year after that. I have it set to fill-in the visit date automatically, but it only shows it one year from the start date. How do I get it to show a visit that is due this year if the consumer started in 1995? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with auto-fill of dates
That worked, thank you!!!
"Sean Timmons" wrote: =if(A1="","",DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1) "artemis1027" wrote: And if a spot is left blank, how do I get it to not automatically fill-in? "Sean Timmons" wrote: =DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1 "artemis1027" wrote: I have a form that tracks when various visits are to be done and when they were completed. One column is a reassesment visit and that is based off of the consumer's start date (another column) and is to be completed 364 days later (another column for the date complete), and every year after that. I have it set to fill-in the visit date automatically, but it only shows it one year from the start date. How do I get it to show a visit that is due this year if the consumer started in 1995? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with auto-fill of dates
Not a problem! Happy to help!
"artemis1027" wrote: That worked, thank you!!! "Sean Timmons" wrote: =if(A1="","",DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1) "artemis1027" wrote: And if a spot is left blank, how do I get it to not automatically fill-in? "Sean Timmons" wrote: =DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1 "artemis1027" wrote: I have a form that tracks when various visits are to be done and when they were completed. One column is a reassesment visit and that is based off of the consumer's start date (another column) and is to be completed 364 days later (another column for the date complete), and every year after that. I have it set to fill-in the visit date automatically, but it only shows it one year from the start date. How do I get it to show a visit that is due this year if the consumer started in 1995? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto dates | Excel Worksheet Functions | |||
| Repeat Section and Auto Fill | Excel Worksheet Functions | |||
| using auto fill edit or fill handel | Excel Worksheet Functions | |||
| Auto tab- Auto fill | New Users to Excel | |||
| Auto fill option box disappeared | Excel Worksheet Functions | |||
Linear Mode
